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

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

Length:
06:03