CODEWITHSUNDEEP
exceldatecountif
user3509034
user3509034

Reputation: 61

Count Number of Cells with Dates that are in a Given Month

I've got several dates in column B3:B62 that appear as mm/dd/yyyy

in cell n4 i want return all the total number of cells that have dates that fall in the month of january

i've tried =COUNTIF(B3:B62;=>"2/1/2014")

this only returns a value error

Upvotes: 0

Views: 6594

Answers (2)

pnuts
pnuts

Reputation: 59450

Please try: 

=COUNTIF(B3:B62;">=1/1/2014")-COUNTIF(B3:B62;">1/2/2014")

and, if that does not work (!) switching "1/2/2014" to "2/1/2014".

Upvotes: 1

user3885927
user3885927

Reputation: 3503

You can do 

=COUNTIFS(B3:B62, ">=1/1/2014", B3:B62, "<2/1/2014")

Microsoft Documentation here

Upvotes: 3

Related Questions