Datedif lets you calculate the difference between dates and display the result in whole Years, Months or Days.  It is particularly useful for tracking years of service, warranty terms, reporting cycles and age. Datedif is not found in Excel’s function list you just need to be in the know. Watch this short video to see how.

[embedyt] https://www.youtube.com/watch?v=xYOzbouXog4[/embedyt]