Counting based on Date Range

T

theboatdude

I have a an Excel spreadsheet that is linked to an Access Databas
Table. Each day, the database is updated with new information
including the date. I want to set up an automated Excel report tha
will count the number of entries for a date range (monthly). In short
I want to reference an entire column (the date column), and have th
spreadsheet be able to count how many entries occurred in Jan 04, Fe
04, etc...

I've played with counta and countif, but have had little success.

Thoughts?

Thankx,

C
 
Top