Member-only story
No Sick Leave in the Weekend
A Coda puzzle with a subtle complexity
After finishing my second blog on sick leave about a month ago, I felt relieved for a few reasons. First of all I was happy that it all worked well, but also I was happy to escape the inertia. The code editor became so slow that any change required an unfair amount of patience on my side.
However I am not done yet as it appears.
The developed logic deals with a list of uninterrupted sick days as indicated by the HRM employee in a table and this defines the days paid by the employer and the days paid by the government.
The challenge
In the overview below we have two lists of two days and the current output is that the employer has to pay two times two days, thus 4 days in total, while the correct outcome is 3 paid days by the employer (…) because the employer has only to pay the first three working days.
This issue would not appear in a logic that asks the HRM employee to set the start and end date of a sick leave. In this approach you would not consider to leave out the weekends or holidays and we would have an uninterrupted…
