Please find the same in the figure shown below.Įxample #3 – Count the number of months between the two dates

Step 4: Now, if we will drag the formula, we will get the result for all the dates.

Step 3: Press Enter, you will find the difference in days between the two dates.

Step 2: Enter DATEDIF Formula in the first row, use YD as a unit in a formula.

Step 1: Use the following data to find the no.

Please find the same in the figure shown below.Įxample #2 – Count the number of days ignoring years

Now, if we will drag the formula, we will get the result for all the dates.

Press Enter, you will find the difference in days between the two dates.

Enter DATEDIF formula in the first row, use D as a unit in a formula.

Use the following data to find the no.

You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked

#6 – YM (Months barring days and years): YM used in a formula to find the date contrast in months, disregarding days and years.

#5 – YD (Days barring years): YD used in a formula to find the date contrast in days, disregarding years.

#4 – MD (Days barring years and months): MD used in a formula to find the date contrast in days, disregarding months and years.

#3 – D (Days): D used in a formula to find the number of days between the beginning date and end date.

#2 – M (Months): used in a formula to find the number of complete months between the dates.#1 – Y (Years): Y used in a formula to find the number of complete years between beginning and end dates.End_date – the ending date of the period.Unit: The time unit to utilize while ascertaining the difference between two dates.Start_date – the initial date of the period you want to calculate.DATEDIf is a date function used to find the difference between two given dates, now these differences can be in years months or days, it takes two dates as an arguments and one keyword to specify which type of difference is desired for the output, the output for this function is integer and the method to use this function is as follows =DATEDIF(Start Date, End Date, Unit), however, this function is compatible with excel 2000 and previous versions of excel.

Datedif in excel