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 certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff 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