Dynamic Calendar Formula Issues in Excel

[excelxzzx]

Hi guys,

I'm trying to create a dynamic calendar in excel and I've used a pre-made template (Please find attached).

The formulas are rather confusing to me and I'm not quite sure how I can edit them. Ideally I would like the calendar to only show the amount of days in the month itself.

For example, In January it shows days 1-31 which is great, however it then displays the last two days in February (Cells AJ 6 & AK6). I want it to only display the days in the month. Is anyone able to edit that for me or tell me how it's done?

Thanks so much!

[Bernie Deitrick]

Copy the formulas from AR6:AR17 to the left, at least until Z6:Z17

[kvsrinivasamurthy]

In C6 then dragged across

Please Login or Register  to view this content.