Formula for Counting End dates and grouping them by Quarters

tim.curtin

Hello!

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,

Tim

Pamelam

Hello,

I do not know if this is the cleanest way, but it should work.

=COUNTIFS([End Date]:[End Date], >=DATE(2022, 1, 1), [End Date]:[End Date], <=DATE(2022, 3, 31))

Good luck!

Pam