Countifs Date Formula


Hi there, I need to create a formula that counts how many dates are less than or equal to the project's completed date.

I have this formula so far, however when I try to add on an "=" with another "Countifs" or "Or" my formula does not function.

=COUNTIFS([Expected Go Live Date]@row, >[Completed Date]@row)

How can I add on to this formula to include if the date is equal to the expected completion date?

Thank you in advance!



  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭

    Hi Natalie K,

    Can you please provide some images for context?

    Thank You!

    Anjanesh Vaidya


    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!