Countif Formula to validate the old dates with in range

Hi All,

I would like to count the column with dates specified with the range

Example below : I need counts for Today Minus last 10 days counts

In excel i can use this formula to validate and give right values


I need the same formula for smart sheet


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!