Date Formula with Threshold

I am trying to count the number of rows that have a date within the following thresholds:

  • Date falls within the next 10 days
  • Date falls within the next 15 days
  • Past due date

I tried the following but realized I don't actually want it to count less than 10 days from TODAY BUT the date in the "Lease Move in Log Range 3."

How would I use that date versus today?

=COUNTIFS({Lease Move in Log Range 2}, Name@row, {Lease Move in Log Range 1}, "", {Lease Move in Log Range 3}, <=TODAY(10))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!