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!!!!

Nel post news:[email protected]
*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")+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.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy