Function calculate date in weeks

Scott · Oct 21, 2003

I would like to know how to calculate the difference
between two date ranges into week numbers.

i.e..2003wk51-2003W50 = 1 week.

Felipe · Oct 21, 2003

Scott,

If dates are in cells A1 and B1:
=(B1-A1)/7