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

=COUNTIF(A2:A15,"<"&TODAY()-7)

I need the same formula for smart sheet


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!