| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of years/months/days between 2 dates
I am looking for a formula that gives me the number of years, months and days
between two dates. e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy) Result: 7 years, 5 months, 17 days e.g. 01/01/2005 - 01/03/2006 Result: 1 year, 2 months, 0 days Thank you for your time. Deborah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES | Excel Worksheet Functions | |||
| Calculate Number of Days Between Dates Minus Weekends | Excel Discussion (Misc queries) | |||
| calculate number of days btw dates | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Find number of days between to dates | Excel Worksheet Functions | |||
Threaded Mode
