Count Status 1 week old

Marilen.Navarro103391

Hello.

Can you teach me how to show in Summary Sheet, count "Untouched" status from Date Created column for one week old from Today.

I know something is wrong with my formula.

=COUNTIFS(Status:Status, "Untouched", [Date Created]:[Date Created], >=TODAY(-7), [Date Created]:[Date Created], <=TODAY())

Thanks!

Jess Bowles

This may not be the best solution, but if you add a column in the sheet and add this formula

=if(and(status@row = "untouched",[date created]@row >= today(-7),[date created]@row <= today()),"1","0")

Then in sheet summary you can do =countif(<column>,"1")

Hope this helped.