Try:

=COUNTIFS($B$4:$B$1504,"C3467",$G$4:$G$1504, ">"&Today()-365)


Regards, TMS