Forum Discussion
Function for specific weekly dates
I'm trying to create a column that is dated as such: January, Monday 4 - Sunday 10 January, Monday 11 - Sunday 17 where only the weeks start at Monday. I think this has something to do with the IF...
You don't really need H6 and I6 for this.
I'd do the following:
Enter the start date January 4, 2021 in cell A6. It doesn't matter how you format it.
In A7, enter the formula =A6+7 and fill or copy this down as far as you want.
In another cell in row 6, enter the formula
=TEXT(A6,"mmmm, dddd d")&" - "&TEXT(A6+6,"dddd d")
Fill or copy down.