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.

Resources