COUNTIFS formula between 2 date ranges Challenge

I want to count the total submitted request for a given year by status. I attached a sample as I'm not getting any results with my formulas...

Try this in D6 on the Summary sheet then copy right and down as required.
=COUNTIFS('Funding Requests (2)'!$L:$L,$C6,'Funding Requests (2)'!$BD:$BD,">="&DATE($D$5*1,1,1),'Funding Requests (2)'!$BD:$BD,"<="&DATE(D$5*1,12,31))

Then go to column BD on the Funding Requests sheet, select the whole column then "Data / Text to columns / Finish". That will force your dates from a text format to an actual date format.

Hopefully that will make everything add up as expected.

BSB

The text to columns part of the above (post #2) may not be necessary depending on your local settings. The dates show as text for me but may not for you.
difficult to guess as your profile doesn't give us any detail on where you're based.

BSB