Date Range in formula unparseable

Sandra Unger
Sandra Unger ✭✭✭
edited 09/23/21 in Formulas and Functions

Hi I would be very appreciative if someone could help me solve this date range formula.

=COUNTIFS(Status:Status, "Complete", [IS&T Services]:[IS&T Services], "<>Public Safety", [IS&T Services]:[IS&T Services], "<>Cross Functional", [IS&T Services]:[IS&T Services], "<>SubProjects and Tasks", [Actual Finish]:[Actual Finish], >=DATE(2020, 7, 1), [Actual Finish]:[Actual Finish], <=DATE(2021, 6, 30)))

I want to count the number of completed projects between July 1, 2020 and June 30, 2021.

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!