Скачать или смотреть Excel - Calculate the Difference Between Two Dates in Excel using DATEDIF Function - Episode 357

Microsoft Excel Tutorial - Calculate the Difference Between Two Dates in Excel using DATEDIF Function.

Welcome back to another episode of the MrExcel podcast! In this video, we'll be discussing how to calculate the difference between two dates in Excel. This is a common question that many viewers have asked, and I'm excited to share with you a simple solution using the DATEDIF function.

First, we have our dates in column A and today's date in column B. While you can use the =TODAY function in column B, we'll be using the DATEDIF function to calculate the difference in years and months. This function has been around since the Lotus 1-2-3 days and is still available in Excel today.

To use the DATEDIF function, simply specify the earlier date, the later date, and the unit you want to calculate. For example, if we want to see the number of years between the two dates, we would use the code "Y". This will tell us that 34 years have elapsed between the two dates. Similarly, we can use "M" for months and "D" for days.

However, in this case, we want to ignore the 34 years and only focus on the number of months. To do this, we use the code "YM" in the DATEDIF function. This will give us the number of months between the two dates, ignoring the years. We can also use "MD" for days ignoring months, or "YD" for days ignoring years.

But what if we want to show the difference in years and months as a fraction? Well, we can do that too! In column E, I've used a formula that takes the number of years and months and divides it by 12. Then, by formatting the cells as a fraction with a denominator of 12, we can get a nice number like 36 and 11/12, which represents 36 years and 11 months.

So there you have it, a simple and efficient way to calculate the difference between two dates in Excel using the DATEDIF function. I hope you found this video helpful and be sure to subscribe to our channel for more Excel tips and tricks. Thanks for watching and we'll see you in the next episode of the MrExcel podcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Introduction to the topic of calculating elapsed time between two dates
(00:24) Explanation of the DATEDIF function and how to use it
(00:49) Using the "YM" code to calculate months ignoring years
(01:31) Using the "MD" and "YD" codes to calculate days ignoring months and years
(01:41) Using a formula to show years and months as a fraction
(02:17) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Ancient DATEDIF function
Calculate elapsed time in Excel
Calculate years and months in Excel
DATEDIF function
Excel formula for years and months
Excel podcast from MrExcel
Format Cells in Excel
Fraction formatting in Excel
Ignore months and years in Excel date calculation
Ignoring years in Excel date calculation
Lotus 1-2-3 days


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

You have two dates in Excel and want to find the elapsed years and months. The solution is to use an ancient function from the days of Lotus 1-2-3. Episode 357 shows you how to use the function, as well as a cool formatting trick to show years and months in the same cell.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!