Forum Discussion
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 all of 2020. I tried using Excel help to re-format the fill function, but that did not work. Thank you for any and all of your help.
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.
7 Replies
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.
If you already have the dates, you can just use WEEKNUM ( ) to get the week number of the year.
Hi ChrisMendoza -
Thank you so much for your note, but I am trying to get it in the format as follows:
1/6-/12
1/13-1/19, etc.
Best,
Mary
