Excel Hack 86: Build a dynamic calendar in MS Excel – in minutes!
A dynamic calendar in Excel is set up to present the calendar for a selected month and year and automatically updates when the month and year are changed. There are preset Excel templates containing dynamic calendars that are accessible to all Excel users from the File>New options. These have been created with complex array formulas