counting occurrences in a given month
Posted by keke on July 26, 2001 12:13 PM
My workbook has three sheets: one for raw data on printing jobs and two for analysis. The 'workflow' sheet has headings like description, date quoted, quote number, date docketed, docket number, etc. Jobs are entered as they come in for quoting or production.
I need to set up a formula that automatically tells me how many items we quoted in each month and how many jobs we took in (docketed). The dates are formatted like "7/26/01". I came up with =COUNTIF('workflow!'F:F,"7") where column F is the date but it does not seem to read the date correctly.
Can you help? I've gone thru the archives but haven't found anything about counting occurrences of a date.