Hi Guys,
I am banging my head on my keyboard and would love to have a doc help out.
In a roster, I'd like to figure out how to count all public holidays worked / non-worked for the staff. Ideally I'd love a short and easy formula that my brain could process
The formula would look at the date in the roster and see if there is a match in a corresponding public holiday table, if there is it will then look at the corresponding day for the employee, if he worked or not and sum all up.
I have a hard time trying to explain this one, might need to stop looking at it. I tried Index, Lookup, Match and I think I am starting to mix them all up... not ideal.
I have attached the excel sample with the result I'm expecting.
Would love to see if an Excel expert has a minute to share.
Thanks,
Fab
Bookmarks