# HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE

G

#### Guest

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?

F

#### Franz Verga

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 don't write all capitals. It's as you're screaming.

You could use this one:

=(DATEDIF(B27,C27,"Y")+DATEDIF(B28,C28,"Y")+DATEDIF(B29,C29,"Y"))&"YEARS,
"&(DATEDIF(B27,C27,"YM")+DATEDIF(B28,C28,"YM")+DATEDIF(B29,C29,"YM"))&"MONTHS,
"&(DATEDIF(B27,C27,"MD")+DATEDIF(B28,C28,"MD")+DATEDIF(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.