Get days between dates ignoring years

Summary

To calculate days between two dates, ignoring year values, use the DATEDIF function. In the example shown, the formula in D6 is:

=DATEDIF(B6,C6,"yd")

Generic formula

=DATEDIF(start_date,end_date,"yd")

Explanation

The DATEDIF function can handle a variety of "date difference" calculations to calculate the difference between two dates in years, months, and days. DATEDIF takes 3 arguments: start date, end_date, and "unit", which controls which result is returned.

In this case, we want days ignoring years so we supply "yd" for unit. (For the full list of options, see the DATEDIF page).

Once configured, the function is fully automatic and returns a result in the unit requested.

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

This site has some of the best and most informative tutorials out there. Dave's courses are concise and to the point. They are extremely easy to learn based on his method of instruction. they are well worth the money spent.

Sam

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles