# of Completed tasks between 3 and 2 weeks ago?
I can get the number of completed tasks last week (7 days) using
=COUNTIFS(Status:Status, "Complete", Finish:Finish, @cell > TODAY(-7))
How do I get the number of tasks completed, say... between 7-14 days in the past?
thank you,
Best Answer
-
You can do it 1 of 2 ways, you can use an AND formula or just have 2 day formulas.
=COUNTIFS(Status:Status, "Complete", Finish:Finish, @cell > TODAY(-14), Finish:Finish, @cell < TODAY(-7))
OR
=COUNTIFS(Status:Status, "Complete", Finish:Finish, AND(@cell > TODAY(-14), @cell < TODAY(-7))
Answers
-
You can do it 1 of 2 ways, you can use an AND formula or just have 2 day formulas.
=COUNTIFS(Status:Status, "Complete", Finish:Finish, @cell > TODAY(-14), Finish:Finish, @cell < TODAY(-7))
OR
=COUNTIFS(Status:Status, "Complete", Finish:Finish, AND(@cell > TODAY(-14), @cell < TODAY(-7))
-
Nailed it!
Thanks, Eric. Much appreciated
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!