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