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...
If in H6 start day when in A6
formula like
=TEXT($H$6 + (ROW()-ROW($H$6))*7, "mmmm, dddd d") &
" - " &
TEXT($H$6 + (ROW()-ROW($H$6))*7+6, "mmmm, dddd d")and drag it down.