Join Dennis Taylor for an in-depth discussion in this video Calculate dates efficiently using Excel's hidden function - DATEDIF, part of Excel Tips Weekly.
- [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,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.