Forum Discussion
Solved
Week Sequencing
Hi, I am trying to sequence each week of the year in an Excel file. I know how to auto-populate week days using the fill function, but I do not know how to auto-populate one week after the next for ...
Mary, if your data placed like this
enter in B3 formula
=TEXT(DATE(2020,1,6)+(ROW()-ROW($B$2)-1)*7,"m/d") & " - " & TEXT(DATE(2020,1,6)+(ROW()-ROW($B$2))*7-1,"m/d")and drag it down.
Hi Abiola1 -
Thank you so much for your note, but I am trying to get it in the format as follows:
1) 1/6-/12
2) 1/13-1/19, etc.
Best,
Mary
Mary, if your data placed like this
enter in B3 formula
=TEXT(DATE(2020,1,6)+(ROW()-ROW($B$2)-1)*7,"m/d") & " - " & TEXT(DATE(2020,1,6)+(ROW()-ROW($B$2))*7-1,"m/d")and drag it down.
Amazing! Thank you!!
marycmulho , you are welcome