COUNTIFS for individual weeks

I reached out for assistance recently about formulas to count specific projects for individual weeks.  The formula assistance I received counts projects from today + next 7 then 13 days then 21 days.

What the formulas are not doing is only counting from day 8 to day 13 from today. 

Here are my formulas...

=COUNTIFS(Start:Start, <=TODAY(), Start:Start, <=(7))     this one works for current week

=COUNTIFS(Start:Start, <=TODAY(8), Start:Start, <=(13))    this doesn't work, Counts from 0 to 13





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!