Oops, I used H23, and you wanted H123

=IF(H123="","",IF(H123="Not
Scheduled","TBA",WORKDAY(H123,IF(WORKDAY(H123,3)-H1233,IF(J123="LOW
SLIP",1,3),IF(J123="LOW SLIP",3,1)),NWD)))

That should fix it.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Connie Martin" wrote:

I really appreciate you tackling this one! However, this formula is giving
be #VALUE! I'm looking at it and trying figure it out, but can't! What do
you think is giving this return? Connie

"Luke M" wrote:

I believe this is what you wanted:

=IF(H123="","",IF(H123="Not
Scheduled","TBA",WORKDAY(H123,IF(WORKDAY(H23,3)-H233,IF(J123="LOW
SLIP",1,3),IF(J123="LOW SLIP",3,1)),NWD)))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Connie Martin" wrote:

I have this formula that is working great, but I need to expand on it and I
have no idea how:
=IF(H123="","",IF(H123="Not Scheduled","TBA",WORKDAY(H123,IF(J123="LOW
SLIP",3,1),NWD)))
The "NWD" at the end of the formula is a named range of dates (non-workdays).
What I would like to add to this formula is to do with the last part
(H123,IF(J123 ="LOW SLIP", etc.). This is what I need to incorporate in
that: if the 3 days added to the date in H123 includes a weekend, then it
would only add 1 day. But this would only be if J123 has "LOW SLIP" in it,
otherwise it would add the 3 days.
I hope someone can come to my aid because I am tired of updating this
manually.
Thank you. Connie