Member-only story
How to Coda Sick Leave Part I
Registering sick leave and counting employers contributions
When employees are absent due to illness, often the employer has to pay for a certain amount of days (or weeks) hence the government takes over. Rules differ per country, but the general idea is that there is some part to pay by the employer and an other part by the state or Insurance company. The employer part is equal to the normal pay, after you mostly get less.
In our example we assume that the first three working days (which exclude holidays and weekends) are for the employer, the rest for the state. However if it happens that you get ill multiple times per month, the same rule applies for each period. This makes it a complex calculation.
Happily we can rely on the ‘The Max Method’ to get started. This method permits to extract date-ranges from a list of dates and serves as the foundation for our main calculation. Merci Max!
In this first blog I’ll show how to calculate a standard situation. In my next blog I’ll dive into the unavoidable complexities related to the start and end values per of each month.
Getting started
In the table below I show per date the weekends and the holidays for visual inspection. In the case below, we only have pay days on the…
