Skip to content
Gallery
Coda Template : Days, Weeks and Months
A go to template on date related issues
Days
Weeks
Months
Extra
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
12/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
12/14/2024
8
6/13/2021
1
Sunday
12/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.