Forum Discussion
A LAMBDA Exercise
I think I made this exercise too easy. mtarler struck it with a blunt instrument (COUNTIFS) and got the job done. PeterBartholomew1 - I thought I made this one a pain with the holiday pay but you seem to have resolved this one easily working COUNTIFS into your LAMBDA.
I believe SergeiBaklan has a solution that can be scaled to include 3D referencing.
I had to do it. I've updated the workbook, so it now includes 3 months. I've made some design changes: the number for the day of the week is now a true date and a list of holidays is included in the summary sheet.
Yes, there are minor adjustments in previous solution to work with few months. The only, I have a bit different result with you. Calculated weekend hours for Bev
Didn't dig what and where exactly is wrong.
Thanks for catching that one.
I feel silly:
(I've replaced the workbook previously uploaded)
Now we are in sync
