Calculate Length of Service in Excel

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.

Add a Running Total Column to your Spreadsheet

A running total column can be added to a spreadsheet to maintain a cumulative total for a series of values. This could be used to track a list of inventory, or a list of account transactions.

In the example below I want to add a running total of column B into column C.