Learn how to use the DATEDIF function in Excel to calculate the number of days, months, or years between two dates. See the syntax, arguments, examples, and known issues of this function.

How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel.

In a third cell, use the DATEDIF function to find the difference in dates. For more information on the DATEDIF function, see Calculate the difference between two dates.

Lists all Excel functions by their category, such as Logical functions or Text functions.

Learn how to calculate the difference between dates using functions from Google Sheets: DATEDIF, DAYS360, and EDATE. Excel can help you calculate the age of a person in different ways.

To do this task, you'll use the INT function, or the HOUR, MINUTE, and SECOND functions as shown in the following example. Use the information in the following table in a blank worksheet and then modify if necessary.

Berechnet die Anzahl der Tage, Monate oder Jahre zwischen zwei Datumsangaben. Excel stellt die Funktion DATEDIF bereit, um ältere Arbeitsmappen aus Lotus 1-2-3 zu unterstützen. Die Funktion DATEDIF kann in bestimmten Szenarien zu falschen Berechnungsergebnissen führen.

Calcule le nombre de jours, de mois ou d’années qui séparent deux dates. Excel propose la fonction DATEDIF afin d’assurer la prise en charge des anciens classeurs créés dans Lotus 1-2-3. Dans le cadre de certains scénarios, la fonction DATEDIF peut calculer des résultats incorrects.