Countifs for items completed YTD by quarter?
Hi everyone, first time poster here.
I need a formula that will count Buy closings YTD by quarter.
The best guess I have after reading other posts is:
=COUNTIFS([Buy close date]:[Buy close date], > DATE(2021,01,01), [Buy close date]:[Buy close date] < TODAY, [Closing Q]:[Closing Q], Q1)
It's not working but I can't quite piece together where I'm going wrong. Any tips or tricks?
Help Article Resources
Check out the Formula Handbook template!