Vacation Dates

Based on an integrated planning

Christiaan Huizer

Intro

Below the steps we steps we made to get the job done.

step01 → Get all vacation dates with exceptions from the holidays

step02 → We evaluate each date from step01 to check for the period we work with

Step03 → based on the periodes and weekday we get a list of all fitting dates

Step04 → we use the Remainder() to filter out the dates fitting the interval logic

Vacation Hours

Vacation Hours

Name

employee

fromDate

untilDate

step03

step04-solution

theCountedDays

Laurelenn Peeters enjoys 20 vacation days between Sun, Jan 1, 2023 → Thu, Jun 1, 2023

Laurelenn Peeters

1/1/2023

6/1/2023

[1/13/2023][1/14/2023][1/20/2023][1/21/2023][1/27/2023][1/28/2023] Show 119 more

[1/20/2023][1/21/2023][2/3/2023][2/4/2023][2/17/2023][2/18/2023][3/3/2023][3/4/2023][3/17/2023][3/18/2023][3/31/2023][4/1/2023][4/14/2023][4/15/2023][4/28/2023][4/29/2023][5/12/2023][5/13/2023][5/26/2023][5/27/2023]

There are no rows in this table

⁠

Read about how to set up your own dynamic planning ⤵️

⁠

Loading medium.com⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.