Sam, I'm sure someone out there can help, but when you ask your question
using all caps, it is the equivalent of shouting and is not very well
received in this forum.
--
Sincerely, Michael Colvin


"Sam" wrote:

I AM TRYING TO SET UP A SPREADSHEET FOR THE YEARS OF SERVICE OUR EMPLOYEES
HAVE SERVED WITH OUR COMPANY. WE HAVE ONE PERSON WHO RESIGNED AND WAS
REHIRED, TWICE. BELOW IS THE FORMULA I USED FOR EMPLOYEES WHO WERE HIRED AND
ARE STILL CURRENTLY WORKING FOR THE COMPANY.

=DATEDIF(B27,C27,"Y")&"YEARS,"&DATEDIF(B27,C27,"YM ")&MONTHS,"&DATEDIF(B27,C27,"MD")&"DAYS"

PLEASE HELP ME EDIT MY FORMULA FOR THE EMPLOYEE WHO HAS COME AND GONE
SEVERAL TIMES. THESE ARE THE DATES THIS EMPLOYEE HAS SERVED WITH THE COMPANY.
02/01/88 - 05/06/88
01/15/89 - 06/15/06
02/01/99 - PRESENT