Countifs with dates

Kate_

Hi

I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not sure what I'm doing wrong....

 

=COUNTIFS(Created:Created, >= DATE(2020, 1, 1)), <= DATE(2020, 1, 31), [Content type]:[Content type], "Assessment" )  

 

=COUNTIFS ([Created]:[Created], MONTH(@cell) = 12, [Content type]:[Content type], "Assessment" )    

 

Any help would be greatly appreciated :-)

 

Thanks

Kate

 

Paul Newcome

Your second formula should work. Are you getting any errors with that one or is it just not returning the correct count?