Hi All,
I have attached leave planner sample, i am trying to figure out how to highlight the calendar based on the input in the annual leave columns.
I am trying to combine sumproduct formula in August-20 calendar (S5:S12) but it is not working.
However, in September-20 calendar highlights only one date (for eg: Sam Anderson), i need all of his annual leaves should be highlighted.
Appreciate your support to achieve it.
Thanks
Bookmarks