Skip to content
Gallery
Coda Template : Days, Weeks and Months
Share
Explore
Extra

icon picker
Skipping weekends

Few lines of code to skipp weekends in your date range
The logic below checks the number of the days and sets a rule in case the day is a working day (Monday - Friday) it returns the date of that day, if not it provides the next Monday.
I love Monday!
TheDate
TheDayNumber
TheWeekdayName
skipp the weekend
1
6/6/2021
1
Sunday
11/7/2024
2
6/7/2021
2
Monday
6/7/2021
3
6/8/2021
3
Tuesday
6/8/2021
4
6/9/2021
4
Wednesday
6/9/2021
5
6/10/2021
5
Thursday
6/10/2021
6
6/11/2021
6
Friday
6/11/2021
7
6/12/2021
7
Saturday
11/14/2024
8
6/13/2021
1
Sunday
11/14/2024
9
6/14/2021
2
Monday
6/14/2021
There are no rows in this table

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.