Happy Valentine’s Day! Microsoft has a Valentine’s present for us: Excel comments now resemble the comments in Word and PowerPoint, and you can use them for a discussion. If you want the old-style comments, they’re now called Notes.
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.