Using Count If with dates?

Hi Im new to the forum today and could do with a little help!

I am building a spreadsheet to record outstanding and completed jobs over a 12 month period. The end column of each row is the completed date for the job which is displayed as 22-Feb or 1-Mar etc.

I want to count how many jobs were completed in each individual month using the completed date cell but im unsure how I can do this? My old spreadsheet had an extra cell which I simply typed either jan or feb etc into and then I used a count if to display the results. I am trying to reduce the amount of info on the spreadsheet so my ideal answer is to find a way that count if can be used but counts 11-jan, 12-jan, 26-jan all as jobs completed in January.

Thats just my ideal answer and I'm sure its not that simple! Any help would be much appreciated.

Damon

Hello Damon,

Assuming your dates are in column Z and are true dates (i.e. not text) then you can use a formula like this to count all January dates

=SUMPRODUCT((TEXT(Z2:Z100,"mmm")="jan")*(Z2:Z100<>""))

you can do the same for other months. Of course the formula doesn't take account of the year, do you need to do that?

No I dont need the year. Thats great I will give it a try.

Thank you very much
Damon

That works perfectly, Thanks again.