Get the Days, Months, & Years Between Dates in Excel (1 Formula)
How to output the difference between two dates, showing the days, months, and years between those dates.
This tutorial uses one single formula that I show you how to build and change for your needs.
Resources
DATEDIF (Microsoft Resource)
Calculate Difference Between Two Dates (Microsoft Resource)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Tutorial: How to calculate the total number of working days between two dates in Excel. This allow...
Tutorial: I'll explain how dates in Excel work and then point you to many useful tutorials on how t...
Tutorial: How to generate random dates in Excel. This tip shows you how to set a date range and the...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)