For a long time, Excel has had great features for filtering data. These have been commands on the ribbon and menu bars. Now, Excel 365 has a Filter function, meaning you can filter interactively using a formula. This video shows you how.
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.