Forum Discussion

Katie Benoit's avatar
Katie Benoit
Copper Contributor
Sep 25, 2017

Week Number Formula in Excel

Hi All,

 

I need a week number formula to calculate based off of a certain date. Right now I have it set up as =WEEKNUM(B4,1)... Which is calculating the week  number from Jan 1st, to today (9/25/17), which is fine on some but not on others. I have some areas where I need the formula to calculate the week number STARTING at June 5, 2017 to current date. I.E. would be week #23 as of today & not week #39. 

 

Thanks in advance :)

Formulas & Functions
Tutorial
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 25, 2017

    Hi Katie,

     

    You may use 

    WEEKNUM(date,1)-WEEKNUM(<start date>,1)

    or 

    =ROUNDUP((<date>-<start date>+1)/7,0)

    adjusting above depends on you consider the week on start date as 0 or 1

     

     

     

Resources