Excel DATEDIF Function | Excel One Minute Quick Reference

Posted on:  10/07/2021
Excel DATEDIF Function |  Excel One Minute Quick Reference

Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. This is a great function if you work in Human Resources (HR), or any job position where you need the difference in dates. I also use the TODAY function - which I recently covered in two videos and mixed and absolute reference.

DATEDIF Function in Excel

DATEDIF - find years, months, and days between two dates

YouTube Video

Other Excel articles

Syntax for DATEDIF

 

=DATEDIF(start_date,end_date,unit)

 

Units in DATEDIF

UNIT Description
Y The number of complete years in the period.
M The number of complete months in the period.
D The number of days in the period.
MD The difference between the days in start_date and end_date. The months and years of the dates are ignored.
YM The difference between the months in start_date and end_date. The days and years of the dates are ignored.

 

DATEDIF Units - Microsoft Excel

DATEDIF Units - YM is used in this example

Other Excel Articles

Excel SORTBY Function  |  Excel One Minute Quick Reference

Excel SORTBY Function | Excel One Minute Quick Reference

Excel FILTER Function |  Excel One Minute Quick Reference

Excel FILTER Function | Excel One Minute Quick Reference

Excel SORT Function | Excel One Minute Quick Reference

Excel SORT Function | Excel One Minute Quick Reference

Excel DATEDIF Function |  Excel One Minute Quick Reference

Excel DATEDIF Function | Excel One Minute Quick Reference

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting

How to use the TODAY function in Excel

How to use the TODAY function in Excel

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories