Skip to content

How to Calculate the Amount of Time Between Two Dates in Excel

< 1 minute read

Excel Green

[ad-banner image=”×260-1.jpg” url=”″]

Calculating the amount of time between two dates is slightly more complicated than calculating the difference between other types of numbers. The irregular number of days in months, leap years, and other factors make this type of calculation slightly more complex. However, Microsoft Excel has a function you might not know about that’s designed specifically to calculate the amount of time in between two dates.

  1. In Microsoft Excel, list the dates you’d like to calculate the time between. For this example, let’s say cell A1 has one date, and B1 has another.
  2. In a new cell, type in =DATEDIF(A1,B1,”Y”). The “Y” signifies that you’d like the information reported in years. This will give you the number of years between the two dates.
  3. To find the number of months or days between two dates, type into a new cell: =DATEDIF(A1,B1,”M”) for months or =DATEDIF(A1,B1,”D”) for days. 

Click here to watch this video on YouTube.

Sign up for our newsletter