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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE
Nel post
*Susan* ha scritto: 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!!!! Please don't write all capitals. It's as you're screaming. You could use this one: =(DATEDIF(B27,C27,"Y")+DATEDIF(B28,C28,"Y")+DATEDI F(B29,C29,"Y"))&"YEARS, "&(DATEDIF(B27,C27,"YM")+DATEDIF(B28,C28,"YM")+DAT EDIF(B29,C29,"YM"))&"MONTHS, "&(DATEDIF(B27,C27,"MD")+DATEDIF(B28,C28,"MD")+DAT EDIF(B29,C29,"MD"))&"DAYS" -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
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 |