Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL
Sorry! I have never entered a forum before. I didn't know. Thank you for
the advise. -- "Michael" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL
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 "Susan" wrote: Sorry! I have never entered a forum before. I didn't know. Thank you for the advise. -- "Michael" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
how do i calculate age in term of years, months, days | Excel Worksheet Functions | |||
convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
How do i convert years to months (formula) | Excel Worksheet Functions |