# # of Completed tasks between 3 and 2 weeks ago?

Options
edited 04/03/23

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,

• ✭✭✭✭✭✭
Options

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))

• ✭✭✭✭✭✭
Options

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))

• Options

Nailed it!

Thanks, Eric. Much appreciated

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!