Include the Start date in WORKDAY caluclation

[JustHooch]

I'm having trouble figuring out the offset for my WORKDAY formula so that the Start date is included in the calculation.

I know I can change the number of days to account for this (use 0 instead of 1) but Long story short the higher-ups want to see the 1 as it does, in fact, take a 1 day.

Here is my formula in cell H28 now =WORKDAY(F28,-G28,'Dropdown Values'!$B$33:$B$40) the dropdown value being my holiday list.

F28 = 7/10/2018
G28 = 1
H28 = formula calculates 7/11/2018 I want this to be 7/10/2018


I tried just doing an offset but then I get weekends and holidays in my results.

Example: =WORKDAY(F28,-G28,'Dropdown Values'!$B$33:$B$40)+1

F28 = 7/10/2018
G28 = 2
H28 = formula calculates 7/7/2018 this is a Sat...I want it to be 7/9/2018

Please Help!

 

[Tetra201]

Try

=WORKDAY(F28+1,-G28,'Dropdown Values'!$B$33:$B$40)

 

[JustHooch]

that did the trick. Thank you very much.