I have a Google Spreadsheet of line items. One of the columns is a Date field. How can I query (or use a formula) to, for example, get the count of records where the Date field is within February of 2011?
Note: Could use a better title
You need to use 2 formulas.
I assumed that the data was in column B, you will need to adjust accordingly. Copy this formula down the entire column
I assumed that the labels are in column D and the results of the text formula are in column C, you will have to adjust accordingly. Copy this formula into the rest of the cells next to the labels.