Change Values By Picking A Date

[cyberice]

Hi there,

Don’t even know if this can be done but here goes, I am trying to change the values in the cells depending on what date is selected. It is currently set on 18-03-2020in column L but I need to select a date held in column’s L onwards which will change the values.

Regards

[tim201110]

=countifs($k$9:$k$20,"cwr driver",index($l$9:$n$20,,match($c$4,$l$7:$n$7)),"sick")

[cyberice]

Thank you tim201110