If you are using Excel to store data about employees in a
company, you may at some point need to calculate their length of service. Let’s
say we want to return how many years and months an employee has worked for our company.
The DATEDIF function in Excel is used to calculate the
difference between two dates. The difference can be returned as the number of
years, months or days.
As we wish to return the number of years and months that
they have worked we will concatenate two DATEDIF functions together.
