COUNTIFS Formula
I'm having a hard time figuring out the formula to use if I have a column of dates and I want to count how many cells fall between a date range.
I have tried the following formula and the results came back with 0, however I know there there are 7 cells in the column that fall under the date range.
=COUNTIFS(Date2:Date73, >=DATE(2019, 2, 1), Date2:Date73, <=DATE(2019, 2, 28))
HELP!
Comments
-
What would the @cell be?
-
You don't need to change that, its just a function of the formula. It takes your overall range and goes cell by cell to see if it meets the criteria of between 2/1 to 2/28.
-
For more information on @cell see: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell
-
Your original formula should work if you add the @cell before each of your criteria though. The syntax is correct otherwise.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives