Skip to content
Template - The Next Working Day
The Next Working Day
DB Vacations
DB Employees
DB Holidays
DB Work Schedules
Test Table
DB Test Holidays
Untitled page
More
Share
Explore

icon picker
The Next Working Day

A solution for variable working weeks
Christiaan Huizer
The initial challenge was to have a next working day in case of a work week of 5 or 6 days taking into account holidays and already planned vacations. it turned out that there is a more elegant approach available once you dive into the world of sub lists, pairs etc.
Below the blogs that show how you can get the same result as I got, but faster (...). This doc is not for sale nor available for free. You learn how to Coda by doing it and with my blogs you have all the tools (as far as I can see) to make it work for you.
⁠
⁠
Loading
medium.com
⁠
⁠

In this doc you can:

play with vacations
add or alter the regime logic
⁠
Loading
huizer.medium.com
⁠
⁠

⁠
Loading
huizer.medium.com
⁠
⁠


⁠
The Next Working Day
0
Name
dateFrom
dateUntil
workRegime
workingDays
SOLUTION
02-vacations
03-holidays
1
Mr. C. Huizer → 10/12/2022 - 10/13/2022
10/12/2022
10/13/2022
Mr. C. Huizer from 9/1/2022 until 7/31/2023
Monday
Tuesday
Wednesday
Thursday
Friday
10/17/2022
447864478744788447894479044791447924484844915449164491744918449194492044921449224492344924449254492644927449284492944930449314493244933449344493544936 Show 30 more
01/01/202307/04/202312/24/202212/25/20225/29/20239/4/202311/24/20221/2/202312/23/202212/26/2022
2
Mr. C. Huizer → 10/14/2022 - 10/14/2022
10/14/2022
10/14/2022
Mr. C. Huizer from 9/1/2022 until 7/31/2023
Monday
Tuesday
Wednesday
Thursday
Friday
10/17/2022
447864478744788447894479044791447924484844915449164491744918449194492044921449224492344924449254492644927449284492944930449314493244933449344493544936 Show 30 more
01/01/202307/04/202312/24/202212/25/20225/29/20239/4/202311/24/20221/2/202312/23/202212/26/2022
3
Mr. R. Geest → 10/14/2022 - 10/15/2022
10/14/2022
10/15/2022
​
​
​
4480244803448044480544806
01/01/202307/04/202312/24/202212/25/20225/29/20239/4/202311/24/20221/2/202312/23/202212/26/2022
There are no rows in this table
⁠

Can we hire you?

Yes you can. Below my pricing and a section about me. The process:
we have a call (maybe a second one) for free
we decide on the scope of the project
⁠
we fill out a form and sign the agreement
⁠
→ confirmed to you and me by email
we start the project and work as good as we can to reach the goals set

⁠
Loading
coda.io
⁠
⁠

⁠
⁠
christiaan@huizer.be
⁠
|
https://huizer.be
⁠
​
https://huizer.medium.com/
⁠
|
@CodaExpert
⁠
⁠

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.