is there a way to get the week numbers from a date range?
if a have a date range : 1/1/2017 - 2/1/2017, what Week Numbers those dates belong to??
is there a way to get the week numbers from a date range?
if a have a date range : 1/1/2017 - 2/1/2017, what Week Numbers those dates belong to??
I'm not sure if this will work in all cases but try this with your start date in A1 and end date in B1:
=IF(A$1+(ROWS(A$1:A1)-1)*7<=B$1,WEEKNUM(A$1+(ROWS(A$1:A1)-1)*7),"")
Im getting the "" result.
is 1/1/2017 - 2/1/2017 a string in one cell, or dates in two cells?
Ben Van Johnson
two cells. one is "start date" and the other one "end date"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks