Tip 296 – Easily analyse data by month

If you need to summarize a set of data by month, insert a new column next to the date column and enter this formula: =month(A1) to extract the month as a number from the date in cell A1, or =text(A1, “mmmm”) to extract the month in words. Copy this formula down the rest of your cells and then use filters or conditional formulas to analyse your data by month.