Forum Discussion

marycmulho's avatar
marycmulho
Copper Contributor
Jan 10, 2020
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 ...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 10, 2020

    marycmulho 

    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.

ChrisMendoza's avatar
ChrisMendoza
Iron Contributor
Jan 10, 2020

marycmulho -

If you already have the dates, you can just use WEEKNUM ( ) to get the week number of the year.

marycmulho's avatar
marycmulho
Copper Contributor
Jan 10, 2020

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

Resources