In order to re-create the Live Calendar displayed above in the graphics, carry out the following steps after inserting a new workbook in your excel space: (1) Just download the graphics and select B2:H2 and merge the cells choosing Home->Alignment->Merge & Center. (2) Enter a date into the merged range (for e.g. 01-01-2025). The day of the month is not important, so change the format of the cell to a custom format that doesn't display the day: mmmm, yyyy. (3) Enter the abbreviated day names in the cells B3:H3. (4) Select B4:H9, and then enter the array formula to the one in the blue square in the graphic above. (Note: To enter an array formula, press Ctrl+SWhift+Enter. CA Vikram Shankar Mathur 12-Dec-2024 | 03:42 Hours IST | #VSM