Extract data by month and year

I have a large 2 column data set that contains date & time and their corresponding values recorded every 15 minutes (mm-dd-yy h:mm format) for multiple years. I need to create a table that counts the number of data points >zero by month for each year. I titled and formatted the table columns by date, Jan-2020, Feb-2020, etc. off to the side in row 9. I want to search the data set based on the month and year of the column title. I have tried both of the following but get 0 (zero) as a result.

=COUNTIFS($D$10:$D$35049,"="&DATE(YEAR(P$9),MONTH(P$9),1),F10:F35049,">0")
=COUNTIFS($D$10:$D$35049,"="&MONTH(Q$9),$D$10:$D$35049,"="&YEAR(P$9), F10:F35049,">0")

Where dates for the data are in column D, the data are in column F, and row 9 is the targeted month and year, which is column P in this example.

Is there another way to do this?