Formula to count specific month


I'm trying to count a number of projects for a timeline creation. I need a formula to count a project that started in a specific month. My current formula does not work :( this is my formula

=COUNTIF({Project Type}, "Non-infra", {Project or Milestone}, "Project", {start date}, >=DATE(2020, 1, 1), AND({start date}, <= (2020, 31, 01)+""))

Best Answer


  • HueyD
    HueyD ✭✭

    Thanks Mark, it works. Can't believe I missed that step

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!