COUNTIFS Formula

aballard56561

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!

Nic Larsen

Try this:

=COUNTIFS(Date:Date, AND(@cell >= DATE(2019, 2, 1), (@cell <= DATE(2019, 2, 28))))

 

**Edit, I updated it to remove the OR for an AND. Works for me now. **

aballard56561

What would the @cell be?

Nic Larsen

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. 

Mike Wilday

For more information on @cell see: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Paul Newcome

Your original formula should work if you add the @cell before each of your criteria though. The syntax is correct otherwise.