COUNTIFS Formula

Options
aballard56561
edited 12/09/19 in Smartsheet Basics

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