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
