Go Back

Get Days Between Dates Ignoring Years

Get Days Between Dates Ignoring Years

Working with spreadsheets, you will probably deal with dates and time format entries. Also, you might want to get the dates between days ignoring years in Years. If you don’t know how to go about this, just hang on. This blog post will teach you exactly how to do that effortlessly. Just hang on.

What Is the DATEDIF Function?

The DATEDIF function is an inbuilt Excel function that helps you calculate days between two dates, ignoring year values.

It is flexible, robust and has the ability to handle a variety of calculations in date differences between two dates in years, months, and days.



Parameters of the DATEDIF Function

The DATEDIF function accepts three arguments as follows:

Start_ date (required) – represents the start date where calculation begins from.

End_date (required) – means the end date where the calculation stops.

YD (required) – is the difference in days ignoring years.

How the DATEDIF function get days before dates ignoring years in Excel

The DATEDIF function in Excel originates from the now discontinued spreadsheet package, Lotus 1-2-3. Although for unknown reasons, this function only has its documentation in Excel version 2000. However, it can still be used in all Excel versions.

The DATEDIF function takes in three arguments which are:

  • start date,
  • End_date,
  • and “unit”; which in this case is “YD” meaning the difference in days ignoring years.

All of which determines the result returned.

This function is totally automatic. Once all parameters are properly configured, it returns a result in the specified time unit (days).


In this example, you’ll see how to use the DATEDIF function to get days between dates ignoring years in Excel.

This is an illustration to get the days between 1-OCT-1980 and 1-NOV 2017 ignoring years using the formula.


Figure 1. How to get days between dates ignoring years with DATEIF function in Excel 

From the table, the Start_date is in cell B6 and End_date in cell C6 respectively.


The result is displayed in cell D6.


Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I am trying to create a IF formula for the following If years of service is between 1-2 you are entitled to 10 days of vacation between 3-6 you are entitled to 15 between 7-9 you are entitled to 17 10 plus more you are entilted to 20 days After your 10th years, for every 5th anniversary you get an extra 5 days, for example 15th year 25 days, 20th year 25 days so on....
Solved by Z. E. in 11 mins
How to calculate number of days between two dates
Solved by M. U. in 11 mins
I need All dates between 1-59 days highlighted in pink and all dates 60 days and older highlighted in Red.
Solved by A. A. in 20 mins

Leave a Comment