It would be great if we can have a workday function in power automate which can calculate the date by either adding or subtracting the number of days.
For example: If I want to add 5 workdays to 19-02-2021 then the date will be 26-02-2021. The function will exclude the weekends.
Further Enhancement: If we can pass an array of date as an optional parameter which can contain the list of the holidays which should also be excluded while calculating workday.
Syntax: workday ( Start Date, Number of Days, Add/ Subtract, [Optional: Array of holiday dates] )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.