Count on condition between two dates

I have been racking my brain on how to write this formula - for some reason, it did not count anything

What I am trying to do is:

Count "Complete" between two dates. The formula goes:

=COUNTIFS([Actual Start Date]:[Actual Start Date], ">=12/26/2022", [Actual End Date]:[Actual End Date], "<=05/26/2023", Status:Status, "Complete")

What have I done wrong?

Tags:

Best Answer

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭✭
    Answer ✓

    Hi @topazfae,

    Assuming those are actual date columns, you can use the following formula.

    =COUNTIFS([Actual Start Date]:[Actual Start Date], >=DATE(2022, 12, 26), [Actual End Date]:[Actual End Date], <=DATE(2023, 5, 26) ,Status:Status, "Complete")

    Hope this helps,

    Dave

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!