How to use DATEDIF Function in Excel

DATEDIF Function_excel_course_in_hindi

DATEDIF function as the name itself explains the difference between the dates. This function is used to calculate the difference in dates by days, months, or years according to the interval specified in the syntax.

The DATEDIF function is a worksheet function and it returns a numeric value in return. The DATEDIF function is an in-built function in Excel. However, this function is one of the rare function that is not documented while we enter it in the worksheet.

50% OFF on Excel Course

  • Get 2-Year Access with unlimited views of 220+ videos
  • Use Coupon code - NAV50OFF & Start learning

It was only visible in the Excel 2003 version. It is available in all the versions and is also used for calculation it is just not documented.

In other words, the DATEDIF function in Excel calculates the difference between the start date and the end date in days, months, and years. It is said that the DATEDIF function is a hidden function in Excel.

Where,

Start_Date is the starting date of the period you want to calculate.

End_Date is the end date of the period you want to calculate.

The unit is the interval you want to calculate the difference. The unit and their respective explanation are explained below:

UnitExplanation
YThe number of years completed
MThe number of months completed
DThe number of days completed
MDThe difference in days (Months and Years are ignored)
YMThe difference in months (Years and Days are ignored)
YDThe difference in days (Years and Months are ignored)

It is compulsory to enter all the three arguments that are required to calculate the DATEDIF function in Excel.

Below is the detailed Example of each unit which will clear your image regarding the DATEDIF in Excel.

DATEDIF Function Example

1. Calculating the number of days completed between the two dates.

We need to find the number of days between the dates specified. Follow the steps to calculate the number of days between the start date and the end date.

Step 1: In a data set, enter the start date and the end date it different columns or rows. (Here we have entered a Start date in cell A2 and End date in cell B2.)

Datedif function - Data example
Excel DATEDIF Example

Step 2: Start the formula with and “=” equal to sign. (We are entering the formula in cell C2.)

Step 3. Press Enter. The results will be displayed. (Here the Answer will be 1921 days.)

Datedif function in excel- Solution
Excel DATEDIF Result

2. Calculating the number of months completed between the two dates.

While Calculating the number of months completed between the two dates, all the other arguments remain the same as you did above while calculating the number of days between two dates. Expect in the Unit argument instead of writing “d” you need to replace it will “m”.

Datedif function in Excel example 1
Excel DATEDIF Example 2 Result

3. Calculating the number of years between two dates.

Fill in the third argument of the DATEDIF syntax with “y”

Datedif function in Excel example 2
Excel DATEDIF Example 3 Result

(Here the Answer will be 5 years)