# calculate date using networkdays plus 11 business days

#### shellwig

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=WORKDAY(B3-1,C3,A4:A5)``

#### shellwig

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

#### Fluff

##### MrExcel MVP, Moderator
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

##### New Member
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.

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
4
Views
97
Replies
4
Views
493
Replies
1
Views
186
Replies
3
Views
351
Replies
1
Views
889

1,191,690
Messages
5,988,103
Members
440,126
Latest member
duque00

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back