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

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

Resources