Hi,
I'm sure there is a really obvious answer to this but I've tried a ton of combinations with nested ifs, if ANd,IF OR and I'm stuck. Keep getting the error too many arguments for this function..
I'm trying to get it to do this :
=IF(B2="",'"WORKDAY(D2,10)),IF(B2="EXAM",(WORKDAY(D2,15))
(Sorry if my () and ""s are wrong )
So basically if
Column B has no value keep the row blank
If it does column E adds ten workdays to the date in column D
but if column B = exam I want it to be 15 workdays to not 10..
Any help would be much appreciated!