Hi all,
How to count monthwise dates for current year??

This formula will count monthwise but not current year:

Example is for say month of June ( Dates are in column A)
=SUMPRODUCT(--(MONTH(sheet2!A2:A761)=6))
Any suggestions please

Kind regards