Mac Numbers

Highlighting max value

COUNT values between two dates

=COUNTIFS($C$3:$C$10,">="&DATE($K$9,1,1),$C$3:$C$10,"<="&DATE($K$9,12,31))

COUNTIFS(Table 1::$I$2:$I47,">="&DATE($A3,1,1),Table 1::$I$2:$I47,"<"&DATE($A3+1,1,1))