You’re offline. This is a read only version of the page.
Hi guys,
I'm in the middle of building a flow but I'm kinda stuck at the moment.
I built 2 lists on Sharepoint
List 1: Report
List2: Public Holiday Schedule
Then I created a flow in List 1 using 'Specified Date' column
This is all I had built in the flow
My question is how do I recur the Specified Date every month on the 11 business days excluding weekends? Suppose the holiday day falls on Dec 16th, I want it to skip 16th and count 17th as 11 business day.
I really appreciated your help
Hi @Stuznet
I've discovered the solution to this issue for another user here on the community, and I have written a blog article that explains the solution in detail. Check it out here:
https://manueltgomes.com/microsoft/flow/find-next-business-day/
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel
Hi @Stuznet ,
You can use the dayOfWeek() function to determine if the current date is a weekend. Exclude weekends by the returned result. If the returned result is 0 or 6, the current day is the weekend.
Also please refer to this similar thread and see if it helps:
Best Regards,
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (