DATEDIF

Secret DateDif Function in Excel Calculates Years, Months, Days

               

        Sometimes, you need to show each employee’s age in Years and Months. The cool|secret|sometimes buggy =DATEDIF function does the trick.   This function has not been documented since Excel 2000, so figuring out the third argument is the trick. Enter “Y” to get full years. But, if you enter “M”, you(…)

Years Months Days – 1113 – Learn Excel from MrExcel Podcast

               

Med asks how to calculate Years, Months, Days between two dates. Episode 1113 discusses the elusive DATEDIF function. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Learn Excel from MrExcel