Skip to content
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
6/6/2021
1
Sunday
10/7/2025
6/7/2021
2
Monday
6/7/2021
6/8/2021
3
Tuesday
6/8/2021
6/9/2021
4
Wednesday
6/9/2021
6/10/2021
5
Thursday
6/10/2021
6/11/2021
6
Friday
6/11/2021
6/12/2021
7
Saturday
10/14/2025
6/13/2021
1
Sunday
10/14/2025
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.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.