| 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? |
| 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 | |||
Threaded Mode
