Want to Count "Total number of Tasks that are due in next 7 days"

Rafsun Royal

Want to Count "Total number of Tasks that are due in next 7 days"

Currently using this but doesn't work: 

=COUNTIF([Production Move Date]14:[Production Move Date]149, >=TODAY(7))

Please Help!

Andrée Starå

Hi Rafsun,

Try this. (Change Date t your column name)

=COUNTIF(Date:Date; <=TODAY(7))    

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

=COUNTIF(Date:Date, <=TODAY(7))

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

I hope this helps you!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Rafsun Royal

Thanks Andree!

Andrée Starå

Happy to help!

Have a fantastic weekend & Happy Holidays!

Best,

Andrée