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. 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. 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()

Posting Permissions

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