Calculate duration in Excel 2000
 

Is there a formula that will calculate the number of weeks between two
dates?

Many thanks,
babette


--
Babette
------------------------------------------------------------------------
Babette's Profile: http://www.excelforum.com/member.php...o&userid=29012
View this thread: http://www.excelforum.com/showthread...hreadid=487448

Calculate duration in Excel 2000
 

Try

=INT((End Date - Start Date)/7)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"Babette" wrote in
message ...

Is there a formula that will calculate the number of weeks between two
dates?

Many thanks,
babette


--
Babette
------------------------------------------------------------------------
Babette's Profile:
http://www.excelforum.com/member.php...o&userid=29012
View this thread: http://www.excelforum.com/showthread...hreadid=487448