Happy to help, Marc...........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"Marc Shaw" wrote:

Thank you Chuck, I knew it should be an easy formula but the brain just
wasn't clicking.

Thanks again!
--
Thanks,
Marc Shaw


"CLR" wrote:

Something like this might be what you're looking for.........

=COUNTIF(A:A,"=9/1/06")-COUNTIF(A:A,"=10/1/06")

Vaya con Dios,
Chuck, CABGx3



"Marc Shaw" wrote:

I have a column of dates such as 8/5/06, I would like to create a formula
that counts the number of dates for a particular month. For example, if the
column reads as such:
9/13/06
8/28/06
9/20/06
9/20/06
8/20/06
9/22/06
9/22/06

I would like the formula to tell me that there are 2 for the month of
August. Then I could also set up another similar formular to tell me that
there are 5 for the month of September


--
Thanks,
Marc Shaw