Posted to microsoft.public.excel.worksheet.functions

maja

Posts: n/a

i have two days and i want the difference in days, months, year

21/3/2006
20/2/2005

answer must be
1/1/1
one day and one month and one year

thanks

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
convert Days to Years, Months, Days	Klaudebou	Excel Discussion (Misc queries)	3	December 29th 05 10:33 PM
Working days left in the month compared to previous months	qwopzxnm	Excel Worksheet Functions	8	October 24th 05 08:00 PM
Vacation Accrual Formula	MissNadine	Excel Worksheet Functions	0	August 18th 05 04:02 AM
Why "datedif" function results sometimes negative numbers?	Ambrosiy	Excel Worksheet Functions	1	July 8th 05 11:29 AM
difference between two dates in years, months and days.	ruby	Excel Worksheet Functions	2	April 4th 05 04:51 PM

All times are GMT +1. The time now is 02:47 AM.

About Us

"It's about Microsoft Excel"