Counting the number of records in a specific date range

[Jeremy Prosser]

I'm using Excel 2003. I just want to enter a funtion/formula that counts how
many times a record appears in a range between two specific dates rather than
having to filter the records and do a count. I've been trying the COUNTIF
function but without any luck. Example:
=COUNTIF(A1:A200,>=12012008,<=12312008) I know this is completely wrong but
you get the idea. Thanks in advance. Jeremy.

 

[fredg]

I'm using Excel 2003. I just want to enter a funtion/formula that counts how
many times a record appears in a range between two specific dates rather than
having to filter the records and do a count. I've been trying the COUNTIF
function but without any luck. Example:
=COUNTIF(A1:A200,>=12012008,<=12312008) I know this is completely wrong but
you get the idea. Thanks in advance. Jeremy.

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.