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