Datedif function in Microsoft Excel

Posted on:  12/13/2016 Datedif function in Microsoft Excel

To find the difference in years, months, and days between two dates in Excel use the Datedif function. This function will allow you put in the start date, end date, and decide the difference in years, months, or days. It is very handy for HR people.

YouTube video on Dated if function

Function arguments used in the Datedif video below

  • y is the number of years
  • m is the number of months
  • d is the number of days
  • ym is the number of months since the last year
  • md is the number of days since the last month

Download the file used in the video: Datedif_Function_Chris-Menard.xlsx

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories