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
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives