How to Calculate Date Difference in Excel

January 19, 2022

Hey data friends! Today I will show you how to calculate date difference in Excel.

Let’s get started!

We will be working with the data table below.

The sample data set we will use to calculate date differences in Excel
Our sample data set we will calculate date differences on

This table has two different date columns. The first column has the date that each participant started their training course, while the second date column has the date that each participant completed their training course. Our goal today will be to calculate the date difference between these two dates; in other words, we will calculate the numbers of days it took each participant to complete their training course.

Excel Date Difference Formula

Our Excel formula to calculate date difference looks like this:

= Date 1 – Date 2

In our example, we will plug in the formula as follows:

Excel Date Difference formula
Date difference formula in Excel

Our output looks like this:

successfully calculated date difference in Excel!

We’ve successfully calculated the difference between two dates in Excel.

If we wanted to convert the date difference to weeks, we could add in a division by 7 into our existing formula, so that it looks like this:

Calculating date difference in weeks in Excel
Calculating date difference in weeks in Excel

Our outcome would look like this:

That’s all there is to it, now you can calculate date differences in Excel!

As always, if you have any questions or need anything clarified, you can reach me through Twitter DMs @Cest_Nick!

Book a call to explore the different avenues the Analytic Iron team can help You extract insights from Your Data.
BOOK a Discovery cALL