I am looking to put a formula in cell M3 (highlighted in yellow), that looks at cells J3 and K3, if there is a date in cell J3, I want it to take that date and add cell M1 to it, if there is not a date I want it to take cell K3 and add M1 to it. I have tried multiple different formulas and keep reaching a dead end...any help would be appreciated
Cell H3 formula = IF(E3="N",WORKDAY(G3,$H$1,$B$3:$B$30)," ")
Cell I3 formula = IF(E3="Y",WORKDAY(G3,$I$1,$B$3:$B$30)," ")
Cell J3 formula = IF(C3="N",WORKDAY(G3,$J$1,$B$3:$B$30)," ")
Cell K3 formula = IF(OR(C3="Y",E3="Y"),WORKDAY(G3,$K$1,$B$3:$B$30)," ")
**NOTE: All dates are calculated using business days, no weekends (Sat or Sun) and no holidays
Cell H3 formula = IF(E3="N",WORKDAY(G3,$H$1,$B$3:$B$30)," ")
Cell I3 formula = IF(E3="Y",WORKDAY(G3,$I$1,$B$3:$B$30)," ")
Cell J3 formula = IF(C3="N",WORKDAY(G3,$J$1,$B$3:$B$30)," ")
Cell K3 formula = IF(OR(C3="Y",E3="Y"),WORKDAY(G3,$K$1,$B$3:$B$30)," ")
**NOTE: All dates are calculated using business days, no weekends (Sat or Sun) and no holidays
Last edited by a moderator: