Hello, I am not a very advanced user and am trying to do the following:
IF (H4+4 = Saturday, add 2 (H4+6) if H4+4=Sunday, H4+5)
If H4+4= a Holiday, return the next workday, otherwise just add H4+4
So really what I am trying to accomplish is adding 4 days onto the date in cell H4, but the result has to land on a weekday. I have my sheet of holidays, and that weekday formula works on all the other processes, except this one. The weekday formula doesn’t work because it takes out the weekends altogether and adds too many days. I have parts that have to come out of a process that takes 5 days, inclusive of the first and last. There is no one here to take them out on a Saturday or Sunday, or a Holiday but those days are counted as part of the time they are in the process.
I’m not sure if my explanation makes any sense, but thanks in advance.
