Auto Populated Calendar

Hello,

I am wanting to make a calendar that will update automatically to the Month Selected in C4. Ideally once the month is changed the dates would autofill into their correct weekday locations. I was trying to have cell P4 show the weekday of the first of the month in C4. I was then going to use that to drive the value in C6, i.e. if P4 equal Tuesday then C6 equals P4 minus 2. If this is the wrong way to go about this I can go a different route. I ultimately want to be able to use this calendar to show when payments are due on the Data tab on this sheet.

Thank you

For C6

Formula:

Please Login or Register  to view this content.

all others +1


kind regards
Leo