Countifs formula error

Options

within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next week from (day 8 - 13) then week 3 (day 14 - 20).   here's the formula I came up with but it's not working.   

=COUNTIFS(Start1:Start127,"<="&TODAY(+0) ,Start1:Start127,"<="&TODAY(+7)

=COUNTIFS(Start1:Start127,"<="&TODAY(+8) ,Start1:Start127,"<="&TODAY(+13)   

Any ideas how to fix?

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!