Perhaps simpler to explicitly define the start and end dates in two cells, e.g. in K2 use this formula

=DATE(2000+MID(B2,3,2),MONTH(TODAY()),DAY(TODAY()))

and then in L2 to get the date a year later than K2

=EDATE(K2,12)

Then you can use a formula that will sum the relevant data with conditions between those dates, i.e.

=SUMIFS(D:D,C:C,">="&K2,C:C,"<"&L2,G:G,D2)