| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate number of years and months employed using hire date and.
In Excel 2003, I want to calculate the number of years and months employed
using a hire date and the current date. i.e. 06/28/2006 €“ 06/25/2005 = 11 months 06/28/2006 €“ 06/25/2004 = 1 year 11 months 06/28/2006 €“ 08/01/2000 = 5 years 10 months 06/28/2006 €“ 04/01/2000 = 6 years 2 months Somebody must have done this before, yes? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate number of years and months employed using hire date and.
=DATEDIF(start_date,end_date,"y")
=DATEDIF(start_date,end_date,"ym") =DATEDIF(start_date,end_date,"m") -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "TryingTime" wrote in message ... In Excel 2003, I want to calculate the number of years and months employed using a hire date and the current date. i.e. 06/28/2006 - 06/25/2005 = 11 months 06/28/2006 - 06/25/2004 = 1 year 11 months 06/28/2006 - 08/01/2000 = 5 years 10 months 06/28/2006 - 04/01/2000 = 6 years 2 months Somebody must have done this before, yes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| HOW DO YOU CALCULATE AGE BY DATE OF BIRTH I NEED YEARS AND MONTHS | Excel Discussion (Misc queries) | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
| calculate date differences in years and months | Excel Worksheet Functions | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Linear Mode
