Forum Discussion
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 catergory A.
=IF(K3="A","n/a","")&IF(K3="B",WORKDAY(B3,-20, Guidelines!G16:G47),"")
K is the the cell where the meeting category is situated and B is the meeting date. I have added the rule for WORKDAY to exclude bank holidays. The formula works however the result that it creates is not a date (when that is what is needed) but the number of the date. This is despite me formatting the cell to show dates. I can not override the the formatting at all once this number is in the cell.
I am hoping some one can help.
8 Replies
- Delete “”)& after “n/a”, then add ) at the end of your formula.
emilysheffield , I guess you need to apply Date format to your resulting cell.
