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

"Lucy" <[email protected]> skrev i melding
news:[email protected]...
> 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?

[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

"Lucy" wrote:

> 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?