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



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

Source

What to read next...

Leave a Comment