Subtracting dates into weeks...

[Lucy]

I need to subtract dates to give me how many weeks are in between to
specified dates?

e.g. 1/15/02 thru 7/21/05

Help?

 

[Harald Staff]

Subtract the dates and divide by 7. Adjust to your idea of "weeks between
dates".

HTH. Best wishes Harald

 

[SteveG]

Lucy,

Start date in A1 and end date in B1

=(B1-A1)/7

HTH

Steve

 

[Toppers]

=int(EndDate-StartDate)/7)

in your example the results is 183 weeks

HTH