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