This workbook contains a VBA macro that creates a "live" calendar in a worksheet. The days are displayed using a complex array formula. Change the month and year and the calendar updates. Once the calendar is created, you can copy the cells and paste them #xls