Finding Seniority

An Excel file that teaches how to perform Finding Seniority operation.

Excel Dashboard for Finding Seniority

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.