Add (+1) Workday to formula

[hro5e]

Dear all,

Please see my formula below:

=IF(D16="",SUMIF($A$7:$A$36,E16,$G$7:$G$36)+1,IF(D16<>"",WORKDAY(G15,D16),WORKDAY(G15,D16)))

This formula is a little hard to explain with going into masses of details.

If you look at the +1 within the formula, this adds 1day to a date... how do I add a +1 Work Day i.e. not including weekends instead of a +1 day.

Help would be greatly appreciated.

Thanks

 

[Jonmo1]

Assuming that this is returning a valid date..
SUMIF($A$7:$A$36,E16,$G$7:$G$36)

You can use
WORKDAY(SUMIF($A$7:$A$36,E16,$G$7:$G$36),1)

 

[hro5e]

Lifesaver, I thought I had tried this, I just may have entered the formula wrong.

Thank you very much.

 

[Jonmo1]

You're welcome.