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
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives