[youtube width=”640″ height=”385″]http://www.youtube.com/watch?v=xw_1I1oYApw[/youtube]
Between the Sheets — Excel podcast episode 31: Excel’s secret DATEDIF function
A quick and simple way of finding the number of days, months or years between two dates is Excel’s secret DATEDIF function. When you type it in a worksheet, there’s no popup syntax help to indicate the function exists.