Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE
I NEED TO CREATE A SPREADSHEET CALCULATING THE YEARS OF SERVICE EACH EMPLOYEE
HAS WORKED WITH OUR COMPANY. BELOW IS THE FORMULA I USED TO CALCULATE THE YEARS, MONTHS, AND DAYS FOR EVERYONE, BUT WE HAVE ONE EMPLOYEE WHO LEFT THE CO. AND WAS REHIRED A FEW TIMES. =DATEDIF(B29,C29,"Y")&"YEARS, "&DATEDIF(B29,C29,"YM")&"MONTHS, "&DATEDIF(B29,C29,"MD")&"DAYS" BELOW ARE THE DATES THAT SHE CAME AND WENT. (B27) (C27) 02/01/1988 - 05/06/1988 (B28) (C28) 01/15/1989 - 04/24/1998 (B29) (C29) 02/01/1999 - 06/28/2006 HOW DO I CHANGE MY FORMULA TO CALCULATE THESE DATES? PLEASE HELP!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
how do i calculate age in term of years, months, days | Excel Worksheet Functions | |||
how do i calculate age in term of years, months, days | Excel Worksheet Functions | |||
convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions |