Forum Discussion

emilysheffield's avatar
emilysheffield
Copper Contributor
May 23, 2019

Using the WORKDAY formula issues

Hi - Hoping some one can help.    I have written the below formula to deduct 20 working days from a meeting date if the meeting is in category B or to place an n/a in the cell if the meeting is in ...
excel
Formulas and Functions
emilysheffield's avatar
emilysheffield
Copper Contributor
May 24, 2019

Twifoo 

 

Hi

 

Unfortunitly it is still returning the number of the date not the date itself

Twifoo's avatar
Twifoo
Silver Contributor
May 24, 2019
Please attach your sample file so I can see which issues are causing the formula to return the number rather than the date.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 24, 2019

      emilysheffield , you didn't correct your formula as Twifoo  suggested. Your current formula always returns empty string plus possible date for the option B, other words text & number. Excel interprets final result as text.

      For the 

      =IF(K4="A","n/a",IF(K4="B",WORKDAY(B4,-20),""))

      it returns number and with your format it will be shown as date

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 24, 2019
      I will examine your attached file tomorrow. I’m just replying now via mobile phone.

Resources