COUNTIF and Today Formula - How to get this right?

We would like to count how many cases fall within the previous 8 days not including today. We currently have the formula setup as =COUNTIF({Range}, this is counting the current day all the way back to 7 days ago. Please let me know what the appropriate syntax would be. Thank you!


Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    Hi Jonathan.

    Try something using Countifs and include a <= as well.

    =countifs({intake Tracking Range 1}, >=Today(-8),{intake Tracking Range 1}, <=Today(-1))

    This should give you everything from 8 days ago through yesterday. Let me know if that works.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!