Countif formula using a date range

Options
deb_63_hydracor
deb_63_hydracor ✭✭✭✭✭✭
edited 06/16/22 in Formulas and Functions

Hi,

I'm trying to count the number of rows within a specific date range and can't make this formula work:

=COUNTIFS({Date to Deactivate}@row, {Date to Deactivate}@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30))


Thanks for your help!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!