Skip to content

icon picker
Vacation Dates

Based on an integrated planning

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
Name
employee
fromDate
untilDate
step03
step04-solution
theCountedDays
1
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]
20
There are no rows in this table
Read about how to set up your own dynamic planning ⤵️

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.