WORKDAY itself works in reverse, i.e. the second argument can be a negative
number so......

If completion date is in A1 and contract duration (in days) in B1

=WORKDAY(A1,-B1,holidays)

"Daviv" wrote:

Is there a function that calculates the start date given the contract
duration and completion date while excluding the holidays? Similar to
workdays but reverse.
--
Thanks!