I made a simple calendar for any given month in Excel. It works straight out of the box, just copy the calendar and paste to the desired location.
Screenshot of the monthly calendar in Excel
- To edit the month being displayed, simply change the date in top left cell of the calendar
- No VBA required, the entire calendar is made from formulas
Download the Simple Monthly Calendar here.