Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Count on condition between two dates

    ✭✭✭✭
    in Formulas and Functions

    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:
    · Share on FacebookShare on Twitter

    Best Answer

    • Community Champion
      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

      · Share on FacebookShare on Twitter

    Answers

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions