A LAMBDA Exercise

[Patrick2788]

For this exercise I stripped down a calendar template and put in some sample data.  The goal is to obtain gross pay for July for 3 employees.

The data arrangement:

I believe there are several solutions and I welcome them all.  My first take was using REDUCE but I thought I could be more efficient with another approach. My solution is included in the workbook.  I may revisit the REDUCE solution after I've put some more thought into it.

Formulas only please (No fill handle). No VBA.

I'll mention a few who people might be interested in this exercise. All are welcome.

@Peter Bartholomew @mtarler @L z. @OliverScheurich 

[#2]

@Patrick2788 

Thank you, I only try to follow general principals

1) engineering - avoid to combine few functions in one module, that decreases reliability and maintainability

2) coding - function shall be self-explainable to avoid comments as much as possible