Calculate Difference Between two Dates in Excel

Advertisements

Prev Tutorial Next Tutorial

Calculate Difference Between two Dates in Excel

To Calculate Difference Between two Dates in excel, first make all cell (start date and end date) date type. Here we use predefined formula DATEDIF() and press the Enter key to get the result.

Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.

Syntax

DATEDIF(start_date, end_date, unit)

Calculate day

Syntax

DATEDIF(Start_date,End_date,"d")
calculate difference between two dates in excel

Calculate Month

Syntax

DATEDIF(Start_date,End_date,"m")

Calculate Year

Syntax

DATEDIF(Start_date,End_date,"y")
UnitMeaningExplanation
YYearsNumber of complete years between the start and end dates.
MMonthsNumber of complete months between the dates.
DDaysNumber of days between the start date and end date.
MDDays excluding years and monthsThe date difference in days, ignoring months and years.
YDDays excluding yearsThe date difference in days, ignoring years.
YMMonths excluding days and yearsThe date difference in months, ignoring days and years.

Calcuate number of days from today

Use TODAY() function to find number of days from today date.

Syntax

DATEDIF(TODAY(), "5/20/2015", "d")

Prev Tutorial Next Tutorial

Google Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet


For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements