calculate length of service with multiple dates

[txscotty]

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!

 

[Oaktree]

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