# of Completed tasks between 3 and 2 weeks ago?

Allen4480 ✭✭
edited 04/03/23 in Formulas and Functions

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

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    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))


    =COUNTIFS(Status:Status, "Complete", Finish:Finish, AND(@cell > TODAY(-14), @cell < TODAY(-7))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!