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
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!