Forum Discussion
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/1...
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
