How to Make a Monthly Calendar in Excel 2003, 2007 and 2010

• 1. Add Weekday Headers First, you’ll need to add the days of the week as headers, as well as the month title. Leave the first row in your spreadsheet blank. ...
• 2. Add Calendar Title In the first blank row, we will add the current month as the title of the calendar using a formula. ...
• 3. Create the Days in the Calendar ...
• 4. Add Dates