Your One-Stop Solution to Learn Everything You Need About Datedif in Excel

Most of the time, the business data revolves around months, quarters, and years. There are times at which the dates and intervals between them make a huge difference. You cannot go wrong with differences between dates or make mistakes in performance evaluations.

If you're looking for an easy and automated way to calculate date differences, then Excel has the right one for you. The Datediff in Excel is a pre-programmed function that allows users to evaluate the perfect difference between any two business dates with precision regardless of days, months, or years. 

In this tutorial, you will understand Datedif in Excel and how to implement it in real-time. 

PCP in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
PCP in Business Analysis

What Is DateDif in Excel?

DateDif in Excel is a preprogrammed function that allows users to evaluate the difference between any two dates in terms of days, months, quarters, or years. 

The Syntax of DateDif in Excel is as follows:

=DATEDIF (start_date, end_date, unit)

Start Date - Beginning Date

End Date - Ending Date

Unit - Days/Months/Quarters/Years

Following the definition and syntax of DateDif in Excel, try to implement it in real-time.

How to Implement Datedif in Excel?

DateDif In Excel can be implemented with ease in a few simple steps as follows.

  • Step 1: Select the beginning or start date

Datedif_1.

As shown in the image, the first column named "Start Date" will store the beginning or start dates of the calendar. Remember the cell address as you will be using it in the datediff function in Excel.

  • Step 2: Select the end or last date

Datedif_2

As shown in the image, the second column named "End Date" will store the ending or last dates of the calendar. Remember the cell address as we will be using it in the datediff function in Excel.

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

  • Step 3: Implement the datedif in Excel.

Datedif_3.

Select a cell in the third column so that it is adjacent to the start and end dates, as shown below. 

Write down the formula as: 

“=DATEDIF(A2,B2,"y")”

Here, 

  • Datedif if the function
  • Cell A2 is the Start date reference
  • Cell B2 is the End date reference
  • "Y" is the reference to the year's parameter in the difference

The final result will be executed as shown below.

Datedif_4.

You have come to an end of this tutorial on Datedif in Excel. If you have any queries about the topic discussed, please let us know in the comment section below.

Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Enroll now!

Next Steps

"How to Recover Unsaved Data in Excel" can be your next stop. Most of the time, the data or the server systems might collapse. Such incidents result in a loss of data. A few simple steps can help you recover the data, and this tutorial by Simplilearn will help you understand how.

Curious about learning business analytics and searching for the right mentor? Simplilearn's business analytics has got you covered. This Business Analytics certification course offered by Simplilearn will teach you the basic concepts of data analysis and statistics to enhance your data-driven decision-making. This program introduces you to business intelligence tools like Power BI and takes you into the statistical concepts that will help you extract insights from provided data to deliver your reports using professional-level dashboards.

If you have any doubts, please let us know in the comments below, and our Excel experts will resolve them at the earliest.

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors