Skip to content
Template - The Next Working Day
Share
Explore

The Next Working Day

A solution for variable working weeks
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 not 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.

In this doc you can:
play with vacations
add or alter the regime logic



The Next Working Day
0
Name
dateFrom
dateUntil
workRegime
workingDays
SOLUTION
02-vacations
03-holidays
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 10/14/2022
Sunday
Monday
Tuesday
Saturday
10/15/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 10/14/2022
Sunday
Monday
Tuesday
Saturday
10/15/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
Mr. R. Geest from 10/15/2022 until the end of contract
Wednesday
Friday
Tuesday
10/18/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
→ confirmed to you and me by email
we start the project and work as good as we can to reach the goals set



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.