Countifs with dates
Options
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
Comments
-
Your second formula should work. Are you getting any errors with that one or is it just not returning the correct count?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!