View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susan
 
Posts: n/a
Default 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!!!!