# of Completed tasks between 3 and 2 weeks ago?

Allen4480

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,

Eric Law

@Allen4480

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

Eric Law

@Allen4480

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

Allen4480

Nailed it!

Thanks, Eric. Much appreciated