Posted to microsoft.public.excel.worksheet.functions

Megan

external usenet poster

Posts: 56

Difference between two dates rounded up.

I would like to calculate the difference in two dates but in weeks. However
if the result is less than 1 week I would like the result rounded up to 1
week. Can anyone help I have had numerous attempts.

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
difference between dates	Ankur	Excel Discussion (Misc queries)	2	August 6th 06 05:16 PM
difference between dates	RGB	Excel Discussion (Misc queries)	2	July 21st 06 12:42 PM
difference between dates	Clash	Excel Discussion (Misc queries)	4	May 26th 06 08:02 AM
difference between dates	dcccgoose	Excel Discussion (Misc queries)	3	May 15th 06 03:34 AM
difference between two dates	dhouston1000	Excel Discussion (Misc queries)	2	August 24th 05 11:19 AM

All times are GMT +1. The time now is 02:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us