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?

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

HTH. Best wishes Harald

"Lucy" skrev i melding
...
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?

Lucy,

Start date in A1 and end date in B1

=(B1-A1)/7

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=545999

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