< 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.


Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment