Menu

Calculate duration in Excel 2000

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Sandy Mann

Posts: n/a

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I lock info in Excel 2003 and users in Excel 2000 enter info?	Mimmsan	Excel Discussion (Misc queries)	1	September 8th 05 12:12 AM
Excel 2000 and Excel 2003	Silfredo	Excel Discussion (Misc queries)	0	August 9th 05 06:36 PM
Excel Re-calculation 2000 compared to 2003	tonymitchell	Excel Discussion (Misc queries)	1	August 3rd 05 04:22 PM
VBA for Excel 2000 file is corrupt	nkamp	Excel Discussion (Misc queries)	0	May 26th 05 03:37 PM
How do I Break links Using Excel 2000	DaddyMan	Excel Discussion (Misc queries)	1	December 9th 04 10:18 PM

All times are GMT +1. The time now is 09:01 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement