Issue 1:
Your formula criteria is
”Yes”
It should be
"Yes"
See the difference?! You are using char 148 ”, instead of char 34 "

Issue 2:
Enter this in C3 as an array formula (Ctrl-Shift-Enter):
Formula: copy to clipboard
=MIN(IF(E6:E25>TODAY(),E6:E25))