try this:

=SUMPRODUCT(--(A1:A33>TODAY());--(A1:A33<DATE(YEAR(TODAY());1+MONTH(TODAY());1)))

If you need to calulcate curent date too put >= in first formula.
Also change ; to , if needed and extend range