Formula for Counting End dates and grouping them by Quarters


Have a tricky one. I need to create data from our portfolio using our End Date column (mm/dd/yy) to calculate how many were completed each quarter. I was thinking a formula using a date range but I have not cracked the formatting. My best guess was this:

COUNTIFS({End Date}, @cell = "01/01/22 - 03/31/22")

I know this isn't right but hopefully that paints the picture.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!