Calculate duration in Excel 2000

[Babette]

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

Many thanks,
babette

[Sandy Mann]

Try

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

--
HTH

Sandy
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk

"Babette" <Babette.1yx82m_1132701012.1135@excelforum-nospam.com> wrote in
message news:Babette.1yx82m_1132701012.1135@excelforum-nospam.com...
>
> 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
>