it worked for me =COUNTIF(B2:B299, I21).What you are counting tho has to look
like whatever is in I21 so if you are counting dates say for june and you
have june dates in your column,a date of 1/6/2006 formated say mmm so it
shows up as June in I21,that wont count 2/6/2006,or 4/6/2006,it will only
count 1/6/2006
paul

remove nospam for email addy!



"GoodTrouble" wrote:

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...