Forum Discussion
Solved
Annual Leave Spreadsheet
Hi all, I've been tasked with creating an Excel sheet which displays details of employee annual leave. We would have a list of leave dates and the aim would be to display the details in a das...
=SUMPRODUCT(($A3=$A$12:$A$19)*(B$2>=$B$12:$B$19)*(B$2<=$C$12:$C$19))Maybe with this rule for conditional formatting.
=$B$3:$AP$6Conditional formatting is applied to the above range in this example.
=SUMPRODUCT(($A3=$A$12:$A$19)*(B$2>=$B$12:$B$19)*(B$2<=$C$12:$C$19))Maybe with this rule for conditional formatting.
=$B$3:$AP$6Conditional formatting is applied to the above range in this example.