Showing results for 
Search instead for 
Did you mean: 

Workday function in power automate just like what we have in excel.

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] )

Status: New