+ Reply to Thread
Results 1 to 5 of 5

Employment Years of Service for future date formula

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    3

    Employment Years of Service for future date formula

    Hi,

    I was hoping someone would be able to please give me the formula to calculate someone's years and months of service with a company assuming a future end date.

    For example if someone was hired 12/2/02 and was terming the company as of 06/30/12, what formula can I plug in to get the years of service and months with the organization?

    Thanks so much!

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Employment Years of Service for future date formula

    Use DATEDIF,

    =DATEDIF(HireDate,EndDate,"y")&" Years "&DATEDIF(HireDate,EndDate,"ym")&" Months"
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    01-13-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Employment Years of Service for future date formula

    Unfortunately, it gives me an error response saying you have entered too many arguments for this function - Can you please help with this and plug in my dates and test it out and then perhaps send me the answer?

    Thank you so much!

  4. #4
    Registered User
    Join Date
    01-13-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Employment Years of Service for future date formula

    One more thing I am on Excel 2010 version - hope that helps.

  5. #5
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Employment Years of Service for future date formula

    See the attached.
    Attached Files Attached Files

+ 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