Finding the Seniority Period
An Excel file that teaches how to perform Finding Seniority operation.
Excel Dashboard for Finding the Seniority Period
Start and end dates are being verified. Missing days are being evaluated according to a special rule. Leap years are being processed correctly. The total duration is being calculated in years, months, and days. The report field summarizes the results.
Hope it is useful.