Skip to content
Next Working Day
Next Working Day
More
Share
Explore

icon picker
Next Working Day

building your own solution
Christiaan Huizer
DB Days

Question in the community

what if your working week is
different from the USA working week?
⁠
⁠

Below the code snippet:
Sequence(thisRow.theDate + 1,thisRow.theDate + 7).´
Filter(CurrentValue.Weekday().Contains(1,2,3,4,5)).
First().FormatDatetime(10,0)

Next Working Day
0
Name
theDate
theWeekdayName
get the fitting weekdays
the next
1
the next working date is : Mon, May 22, 2023
5/21/2023
Sunday
45068450694507045071450724507345074
Mon, May 22, 2023
2
the next working date is : Tue, May 23, 2023
5/22/2023
Monday
45069450704507145072450734507445075
Tue, May 23, 2023
3
the next working date is : Wed, May 24, 2023
5/23/2023
Tuesday
45070450714507245073450744507545076
Wed, May 24, 2023
4
the next working date is : Thu, May 25, 2023
5/24/2023
Wednesday
45071450724507345074450754507645077
Thu, May 25, 2023
5
the next working date is : Sun, May 28, 2023
5/25/2023
Thursday
45072450734507445075450764507745078
Sun, May 28, 2023
6
the next working date is : Sun, May 28, 2023
5/26/2023
Friday
45073450744507545076450774507845079
Sun, May 28, 2023
7
the next working date is : Sun, May 28, 2023
5/27/2023
Saturday
45074450754507645077450784507945080
Sun, May 28, 2023
8
the next working date is : Mon, May 29, 2023
5/28/2023
Sunday
45075450764507745078450794508045081
Mon, May 29, 2023
9
the next working date is : Tue, May 30, 2023
5/29/2023
Monday
45076450774507845079450804508145082
Tue, May 30, 2023
10
the next working date is : Wed, May 31, 2023
5/30/2023
Tuesday
45077450784507945080450814508245083
Wed, May 31, 2023
11
the next working date is : Thu, Jun 1, 2023
5/31/2023
Wednesday
45078450794508045081450824508345084
Thu, Jun 1, 2023
12
the next working date is : Fri, Jun 2, 2023
6/1/2023
Thursday
45079450804508145082450834508445085
Sun, Jun 4, 2023
13
the next working date is : Mon, Jun 5, 2023
6/2/2023
Friday
45080450814508245083450844508545086
Sun, Jun 4, 2023
14
the next working date is : Mon, Jun 5, 2023
6/3/2023
Saturday
45081450824508345084450854508645087
Sun, Jun 4, 2023
There are no rows in this table
⁠
⁠
Loading
huizer.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.