Adding months to a workday function including holidays

[tobysdhc]

Hello,

I am trying to use a workday.intl function to determine a date 6 months in the future that is constrained by holidays.

Here is my formula

=WORKDAY.INTL(F5,EDATE(F5,6),"0000000",$T$2:$T$521) F5 =9/5/17

the formula is returning 6/8/2136

Does any one know what is causing this error?

 

[wideboydixon]

The second parameter is supposed to be the number of days, not the target date. You could try:

=WORKDAY.INTL(F5,EDATE(F5,6)-F5,"0000000",$T$2:$T$521)

WBD

 

[tobysdhc]

That did it! thank you so much!