Using COUNTIF (?) to list missing training in scheduling spreadsheet

First month: Please try CF-rule:

Formula:

=AND(DATEDIF($C4,F$1,"m")=0,(WEEKDAY(F$1,2)<6))

Second month: Please try CF-rule:

Formula:

=AND(DATEDIF($C4,F$1,"m")=1,(WEEKDAY(F$1,2)<6))

and so on