Unanswered

Business Days

(0) Share

Report

Posted on by Community Power Pla...

Hi I am trying to integrate planner in flows. For which I want to set the due date of a task to 4th business day every month. Since the 4th business day is a variable date. How can I do it? Is there a formula readily available.

All responses (2)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report

Re: Business Days

Hi @Anonymous

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
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: Business Days

Hi @Anonymous ,

Try following expression to get the 4th Working day of given month:
if(equals(dayOfWeek(addDays(startOfMonth(utcNow()),3)),6),addDays(startOfMonth(utcNow()),5),if(equals(dayOfWeek(addDays(startOfMonth(utcNow()),3)),6),addDays(startOfMonth(utcNow()),4),addDays(startOfMonth(utcNow()),3)))

——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.