Hi there,
I need to find the first Monday of each month, but also back date the other dates from the previous month I guess.
I want to type in the first day of the month in cell A6 and then the dates appear below it in order of day.
Start date:
Wednesday, 1st January
Results:
Monday:
Monday, 30th December
Tuesday:
Tuesday, 31st December
Wedesday:
Wednesday, 1st January
Thursday:
Thursday, 2nd January
Friday:
Friday, 3rd January
I know what to do after this point for the rest of the month, it's just the first few cells i'm not sure how to type a formula.
Basically, cell A7 would always be a Monday, A8 always be a Tuesday and so on, so even if the start of the month starts at the end of the week, I want the dates for the previous month also appear starting from the start of the week.
Thanks
Bookmarks