Creating a Date range

I am trying to create a date range and keep getting an error. I would appreciate assistance. Thank you

=COUNTIFS([Business Unit]:[Business Unit], "CAI Business", Status:Status, "In Progress", (AND [Start Date]:[Start Date] >4 / 1 / 21, [Start Date]:[Start Date]<06/30/21))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!