Do you know you can group dates in pivot tables to show the report by week, month or quarter? I have learned this trick while doing analysis on a pivot table today. Jul 15, 2011  · . Count if Date is in Month. (MONTH(A1:A4)=1))–Biff Microsoft Excel MVP. Biff Microsoft Excel MVP KISS – Keep It Simple Stupid. Excel / Other/unknown / Date and Time in Excel. Placing a current date or…