Results 1 to 2 of 2

calculate length of service with multiple dates

This is a discussion on calculate length of service with multiple dates within the Excel Questions forums, part of the Question Forums category; I need to be able to determine an employee's seniority date (based on actual time worked) between several dates. The ...

  1. #1
    New Member
    Join Date
    Jul 2007
    Location
    Texas
    Posts
    1

    Default calculate length of service with multiple dates

    I need to be able to determine an employee's seniority date (based on actual time worked) between several dates.
    The example is that the original hire date is:
    hire(rehire) dates term dates
    3/31/2000 2/6/2004
    1/5/2005 10/5/2007
    9/22/2008

    The length of service the amount of time served between the hire(re) dates and the term dates and also between the last hire and today.
    The seniority date would have to be moved from 3/31/00 to another date that incorporates the length of his absences (something around 22 months and 17 days later).

    Thank you!

  2. #2
    MrExcel MVP Oaktree's Avatar
    Join Date
    Jun 2002
    Location
    Chicago, IL
    Posts
    7,740

    Default Re: calculate length of service with multiple dates

    Welcome to the board.

    If you're OK with the seniority being in days, try:

    =SUMPRODUCT(B1:B3-A1:A3)

    where A1:A3 and B1:B2 are as you posted and B3 has =TODAY()
    "The greatest challenge to any thinker is stating the problem in a way that will allow a solution." Bertrand Russell

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com