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