Hi, in this blog post i am going to tell you How calculate Date in Excel or you say difference between two dates.

It very easy find Years, Months & Days between two dates using DATEDIF Function. The DATEDIF function in Excel calculates the difference between two dates in terms of years, months, or days. Here's the basic syntax:

=DATEDIF(start_date, end_date, unit)

Here: start_date is the start date, end_date is the end date. unit is a string specifying the unit of time you want the difference in ("Y" for years, "M" for months, "D" for days).

For example, if you have the start date in cell A1 and the end date in cell B1, you could calculate the difference in years with:

=DATEDIF(A1, B1, "Y") for Years

=DATEDIF(A1, B1, "M") for Months

=DATEDIF(A1, B1, "D") for Days


Date Calculate in Excel


Download this Excel Sheet here