Calculate dates efficiently using Excel's hidden function - DATEDIF

- [Voiceover] A powerful yet not so well-known…function in Excel is called datediff.…And there's something very strange about it.…If you had heard about the function,…and maybe heard a brief description…of the fact that it can handle…differences in dates to tell you…how many years, months, days have passed.…If you forgot about that and came back later…and tried to find it by going to the Formulas tab…and clicking Date & Time, you will not…see datediff here, and yet it does work.…And further more, if you're using…Excel for the Mac, in recent versions…until Excel 2016 for the Mac, you will find it documented.…

In the current version, 2016 for the Mac,…it's not found there either, although it works,…as we're about to see as it does…here too in Excel 2016 for Windows.…So equal datediff allows us to…calculate the difference in dates.…And if you look over in column G,…I'll scroll over there a little bit,…you'll see different kinds of entries…that we ultimately can put in here,…different kinds of measures.…Nearly always when you have an age column,…