Excel Magic Trick #151: DATEDIF function (between two dates)

Excel Magic Trick #151: DATEDIF function (between two dates)

HomeOther ContentExcel Magic Trick #151: DATEDIF function (between two dates)
ChannelPublish DateThumbnail & View CountActions
Channel Avatar excelisfun2008-11-19 18:06:13 Thumbnail
425,693 Views
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT146-154.xls
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT146-154Finished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm

Calculate the days, months or years between two dates. See how to use the undocumented Excel DATEDIF function. See how to:
1) Calculate the number of completed days between two dates d
2) Calculate the number of completed months between two dates m
3) Calculate the number of completed years between two dates y
4) Calculate the number of days after completed years yd
5) Calculate the number of months after completed years my
6) Calculate the number of months after completed years ym

Please take the opportunity to connect and share this video with your friends and family if you find it useful.