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 ...
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
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).
Welcome to the board.
If you're OK with the seniority being in days, try:
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