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