COUNTIF and Today Formula - How to get this right?

Jonathan Dayan

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!

Mike Wilday

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.

Jonathan Dayan

=COUNTIF({Intake Tracking Range 1}, >=TODAY(-7))

Jonathan Dayan

https://community.smartsheet.com/discussion/comment/300281#Comment_300281

This what we currently have set up, it did not properly post in my original question. Thank you in advance.

Mike Wilday

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.

Jonathan Dayan

https://community.smartsheet.com/discussion/comment/300287#Comment_300287

It worked, thank you very much!