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
Twifoo's avatar
Twifoo
Silver Contributor
May 23, 2019
Delete “”)& after “n/a”, then add ) at the end of your formula.
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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 24, 2019

    emilysheffield , I guess you need to apply Date format to your resulting cell.

    • emilysheffield's avatar
      emilysheffield
      Copper Contributor
      May 24, 2019

      Hi SergeiBaklan 

       

      As explained above - the cell is formated to Date

  • 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

Resources