+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Sam
    Guest

    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. #2
    Michael
    Guest

    RE: 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. #3
    Susan
    Guest

    RE: 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. #4
    Michael
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1