How to find Week Number between 2 dates

Dear All,

I need help to get the Weeknumber between 2 dates vertically stacked up (they are in rows).

for e.g Start Date in B2 is 3-Feb-20
End Date in B3 is 9-Feb-20

then i need result in B4 as Wk-6. I will count my week start from Monday of every week.

Any single formula which can achieve this


Thanks,
Mahesh

Please Login or Register  to view this content.

but what result must be here if 3-Feb-20 and 16-Feb-20 ?

Thanks...that was so easy! i was stuck with the end date and i couldn't realize that if i put this formula to only apply for start date, it would give me the result.

Nevertheless, the dates are always going to be start & end dates of a week, so my end date would always be start date+7.

Marking this thread as solved.