When you’re done, drag this box down each week so that every Monday has the same formula (adding 1 to the previous Sunday).
Drag the formula from the previous Tuesday down through the month as well, and then drag from Tuesday across each week.
And there you have it, your custom calendar template that you can reuse over and over again.
If you need a quicker solution, you can also check out these Microsoft Office calendar templates Ryan has a BSc degree in Electrical Engineering.
Make sure the Page Setup is configured as shown here.
Set the format for Landscape, and fit the entire calendar to 1 page wide by 1 page high.
The first thing you’ll need to do is create the weekday header as well as the month title.Click OK, and when you do a print preview you’ll find that your calendar template is formatted on one sheet and ready to print!The next month, just open up the same Excel file (the month will already be correct), renumber the days and click Print — it’s as simple as that!He's worked 13 years in automation engineering, 5 years in IT, and now is an Apps Engineer.A former Managing Editor of Make Use Of, he's spoken at national conferences on Data Visualization and has been featured on national TV and radio.