Multiple Formulas in One Cell

[acappiello]

This is what I have

I need this formula

=IF(I5="M-S",IF(E5="W",WORKDAY(A5,-9),IF(E5="BW",WORKDAY(A5,-14))))

AND all of these in one cell

=IF(I5="T-M",IF(E5="W",WORKDAY(A5,-9),IF(E5="BW",WORKDAY(A5,-14))))

=IF(I5="W-T",IF(E5="W",WORKDAY(A5,-8),IF(E5="BW",WORKDAY(A5,-13))))

=IF(I5="T-W",IF(E5="W",WORKDAY(A5,-7),IF(E5="BW",WORKDAY(A5,-12))))

=IF(I5="F-T",IF(E5="W",WORKDAY(A5,-6),IF(E5="BW",WORKDAY(A5,-11))))

Thanks!

 

[MarcelBeug]

Welcome to the forum.

My suggestion would be:

=IF(OR(E5="W",E5="BW"),WORKDAY(A5,CHOOSE(MATCH(I5,{"M-S";"T-M";"W-T";"T-W";"F-T"},0),-9,-9,-8,-7,-6)-5*(E5="BW")))

If E5 will always be W or BW, then you can leave out the IF:

=WORKDAY(A5,CHOOSE(MATCH(I5,{"M-S";"T-M";"W-T";"T-W";"F-T"},0),-9,-9,-8,-7,-6)-5*(E5="BW"))

If E5 is anything else than W or BW, then the first formula willl return FALSE, according to the formulas you supplied.

 

[acappiello]

This seems to be the direction I want to go with, however my dates are off for everything but m-s. Where in the formula can I edit those?

 

[MarcelBeug]

What do you mean: off? Can you give an example?
Otherwise it shouldn't be too difficult to identify the elements from your inputs in the formula.

By the way: shouldn't you account for any holidays as 3rd argument of the WORKDAY function?