Forum Discussion

spalmer's avatar
spalmer
Brass Contributor
Aug 26, 2023

Excel Formula Help

Hi all, in the worksheet attached I enter the person's First Work Day (FWD) in cell E5.  In F5 it automatically adds 14 days.  In cell J5, if they say Yes to extending I want the formula in F5 to add...
  • HansVogelaar's avatar
    Aug 26, 2023

    spalmer 

    Use

     

    =IF(E5="","",E5+13+7*(J5="YES"))

     

    By the way, shouldn't it be

     

    =IF(E5="","",E5+14+7*(J5="YES"))

Resources