+ Reply to Thread
Results 1 to 2 of 2

Calculate number of years and months employed using hire date and.

  1. #1
    TryingTime
    Guest

    Calculate number of years and months employed using hire date and.

    In Excel 2003, I want to calculate the number of years and months employed
    using a hire date and the current date. i.e.
    06/28/2006 – 06/25/2005 = 11 months
    06/28/2006 – 06/25/2004 = 1 year 11 months
    06/28/2006 – 08/01/2000 = 5 years 10 months
    06/28/2006 – 04/01/2000 = 6 years 2 months

    Somebody must have done this before, yes?


  2. #2
    Peo Sjoblom
    Guest

    Re: Calculate number of years and months employed using hire date and.

    =DATEDIF(start_date,end_date,"y")

    =DATEDIF(start_date,end_date,"ym")

    =DATEDIF(start_date,end_date,"m")

    --

    Regards,

    Peo Sjoblom

    Excel 95 - Excel 2007
    Northwest Excel Solutions
    www.nwexcelsolutions.com
    "It is a good thing to follow the first law of holes;
    if you are in one stop digging." Lord Healey


    "TryingTime" <TryingTime@discussions.microsoft.com> wrote in message
    news:732070F3-38CC-4883-9866-46FEA8DEACB2@microsoft.com...
    > In Excel 2003, I want to calculate the number of years and months employed
    > using a hire date and the current date. i.e.
    > 06/28/2006 - 06/25/2005 = 11 months
    > 06/28/2006 - 06/25/2004 = 1 year 11 months
    > 06/28/2006 - 08/01/2000 = 5 years 10 months
    > 06/28/2006 - 04/01/2000 = 6 years 2 months
    >
    > Somebody must have done this before, yes?
    >




+ 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