Ok, I messed with it some more, and have it half way working...

I made the formula:

=COUNTIF(B2:B299, ""&I21) where I21 is the cell storing the month name, the
date I worked being in the range B2:B299. Now, the problem is, even if I go
past the month of June for example, it still counts it because I don't know
how to stop it.

Say July is stored in cell I22, I need something like =COUNTIF(B2:B299,
""&I21&<I22) but that will of course not work.

"GoodTrouble" wrote:

I have a spreadsheet that calculates various percentages and what not based
on tips for days, weeks, and months. I need a formula that can take data from
a colum containg dates in the d-mmm format, and count how many days I have
worked in that month. I list each day seperatly, so I was thinking that some
variation of COUNTIF might work.

I have tried to get it to work many different ways, and cannot. Please Help...