Countifs for current quarter

[Godders199]

Good morning, i need to change this formula to count if in current quarter rather than month, I have tried changing month to quarter, but that does not work, does any one know what i need to change in this formula to count matches in the current quarter. it works perfectly for months.

=COUNTIFS(Allocation!H:H,'Instructions '!L4,Allocation!AB:AB,"<="&EOMONTH(TODAY(),0),Allocation!AB:AB,">"&EOMONTH(TODAY(),-1))

Thanks

 

[arthurbr]

Google is your friend https://stackoverflow.com/questions...-occurences-per-day-months-quarter-with-excel

You might also consider a Pivot Table