FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE

G

Guest

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
 
G

Guest

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.
 
G

Guest

Your welcome, Susan. That's just something you pick up after visiting the
forum for awhile. The only other thing that I've found is that, if you have
complicated formula or code problem, provide an example of what you're using
that isn't working.
Sincerely, Michael Colvin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE 1
Summary of Difference between dates in years, months, days 3
Calculating time between mulitple dates 4
Calculating Years and Months Between Dates 2
Calculate Years/Months Between Dates and then Average 3
Nested IF formula question 3
changed DOB to age, but if no DOB need cell to be empty. 4
Calculate difference in dates 11

Top