DATEDIF function

Excel DATEDIF Function is a useful tool for calculating the difference between two dates in a simple and straightforward way. It allows you to find the number of years, months, or days between two dates, making it handy for various tasks like tracking project timelines, calculating age, or determining the duration of an event.


The syntax for the DATEDIF function is:

DATEDIF(start_date, end_date, “unit”)


Here are the arguments you can use with the DATEDIF function:

start_dateThe initial date.
end_dateThe ending date.
“unit”The unit of time for calculation, such as “Y” for years, “M” for months, or “D” for days.

How to Use

Using the DATEDIF function is quite simple. Let’s see some examples to understand it better:

Example 1: Calculate the number of years between two dates

This formula calculates the number of complete years between the dates in cells A1 and B1.

Example 2: Calculate the number of months between two dates

This formula computes the number of full months between the dates in cells A2 and B2.

Example 3: Calculate the number of days between two dates

Here, the formula determines the number of complete days between the dates in cells A3 and B3.

Additional Information

The DATEDIF function is not officially documented in Excel, but it is a well-known and widely used function. However, be cautious when using it, as it may not be supported in some Excel versions. In addition, be mindful of the formatting of your dates, as this can affect the results. For more information on date formats and Excel functions, you can refer to Microsoft Excel’s official support page.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.