Counting based on Date Range

  • Thread starter Thread starter theboatdude
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup date range row A and count if leave in same column on row B 6
COUNT BETWEEN A SPECIFIC DATE RANGE 4
Count Dates between Dates exclude Text 3
Counting dates before today 6
Counting an Unknown Range 1
Help with counting between dates 4
Counting with multiple criteria in separate Columns 6
Counting Cells with Multiple Range Criteria (Excel 2003) 7

Back
Top