Forum Discussion
Solved
Week Numbers between a Start and End Date
Hi All I dont know if anyone can help!! a concept that sounds simple in my head is just not coming into fruition when im trying to do it in Excel. I am trying to find a formula that will calc...
Hi Susan,
If you'd like to calculate number of full weeks from Start Date that could be
=INT((<your date> - <Start date>)/7)
Or
=ISOWEEKNUM(A1)
if you are in this system