Results 1 to 3 of 3

Thread: Need a formula to calculate years/days/months among several date in Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    83

    Need a formula to calculate years/days/months among several date in Excel

    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. Try the same =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
    Join Date
    Jun 2011
    Posts
    798

    Re: Need a formula to calculate years/days/months among several date in Excel

    I am 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.

  3. #3
    Join Date
    May 2011
    Posts
    410

    Re: Need a formula to calculate years/days/months among several date in Excel

    Your welcome. 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.

Similar Threads

  1. How to calculate months from Today in Microsoft Excel
    By Ramanujan in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 04:38 PM
  2. How to calculate formula as per run rate in Excel
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 04:58 PM
  3. I am looking for a formula to calculate compound interest in Excel
    By Corey Dunnett in forum MS Office Support
    Replies: 3
    Last Post: 03-02-2012, 06:05 PM
  4. What is the formula for Excel to add days excluding holidays
    By Krupanath in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 02:08 PM
  5. Formula to calculate date of delivery
    By abz54 in forum Microsoft Project
    Replies: 2
    Last Post: 08-10-2011, 05:07 PM

Tags for this Thread

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
  •  
Page generated in 1,711,633,881.34672 seconds with 17 queries