How to create formula to count over the past seven days

Emily Alpert

Hello,

I'm trying to count the number of projects delivered in the past seven days. This is what I have so far:

=COUNTIFS(Status:Status; "Delivered";Delivery Date:Delivery Date; >=TODAY(-7))

I'm not sure what's going wrong or where to insert the formula in the sheet (will any cell do?).

Thanks,

Emily

Andrée Starå

Hi Emily,

Try something like this.

=COUNTIFS(Status:Status; "Delivered"; [Delivery Date]:[Delivery Date]; >=TODAY(-7); [Delivery Date]:[Delivery Date]; <=TODAY())

The same version but with the below changes for your and others convenience.

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

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD