calculate date using networkdays plus 11 business days

[shellwig]

Hi All - My goal is to calculate the date excluding saturday and sunday and US holidays and add 11 business days. I believe my formula fails on the business days portion

The formula I am using is NETWORKDAYS(B3+C3,A4:A5). I'm looking for my return to be 1/18/2022. I'm sure it's a simple fix but having trouble figuring it out.

Thank you all,
Shamus

 

[Fluff]

How about

=WORKDAY(B3-1,C3,A4:A5)

 

[shellwig]

That works. Thank you! What does the -1 represent?

 

[Fluff]

Because you want to count the date in B3 as the first (of the 11 days) you need to subtract 1 from it, so that the formula starts on the day before.

 

[shellwig]

Because you want to count the date in B3 as the first (of the 11 days) you need to subtract 1 from it, so that the formula starts on the day before.

Thank you very much for your prompt explanation and answer to address my formula error.

 

[Fluff]

You're welcome & thanks for the feedback.