Excel Guides

Determining Differences Between Dates in Excel

When working with dates in Excel, it is often necessary to calculate the difference between two dates. This can be done in a number of ways, but the most straightforward way is to use the DATEDIF function.

The DATEDIF function takes three arguments: the start date, the end date, and the unit of time to use for the calculation. The unit of time can be days, months, or years. For example, to calculate the number of days between two dates, you would use:

=DATEDIF(start_date,end_date,"d")

To calculate the number of months between two dates, you would use:

=DATEDIF(start_date,end_date,"m")

And to calculate the number of years between two dates, you would use:

=DATEDIF(start_date,end_date,"y")

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.