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
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 (