Posted to microsoft.public.excel.worksheet.functions

Khurum

external usenet poster

Posts: 8

Difference between dates

Hi

I need to work out the difference between todays date and a previous date,
but I want the answer in this format:

Years & Months & Days

Is this possible? I can use today date minus the date and change the format
to show the difference in days. Any way to then change this to the needed
format?

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 of two dates	Zafar	Excel Worksheet Functions	3	July 26th 07 08:44 AM
Difference of two dates	sajan chauhan	Excel Discussion (Misc queries)	3	June 5th 07 04:47 AM
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 05:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us