Leave Blank if #Error

[JaclynB]

Hello,

I'm current working with this formula:

WORKDAY({Start Date},{SLA Test})   ---which is the formula in the 'due date' column.

I would like for the Due Date to be left blank instead of #Error if there is no start date or SLA.

Can someone help with an additional formula that I could add to the one above? 

Thank you. 

[aleaja · Accepted solution]

You could write this at least two ways.

1) Using ISERROR:

IF(
  ISERROR(
    WORKDAY(
      {Start Date},
      {SLA Test}
    )
  ),
  "",
  WORKDAY(
    {Start Date},
    {SLA Test}
  )
)

2) Checking for values in the relevant fields:

IF(
  AND(
    {Start Date},
    {SLA Test}
  ),
  WORKDAY(
    {Start Date},
    {SLA Test}
  ),
  ""
)

[JaclynB]

Thank you. How do I add the original formula and one of the formulas you provided? Can I have two formulas together? If so, how does it look? 

[aleaja · Accepted solution]

Hi @JaclynB, both of the formulas in my initial response include your original formula. The two formulas I offered are two ways of doing the same thing. You can use the one you prefer.

[JaclynB]

Thank you for your help. The errors are gone however the formatting is not correct. Can you help me so it shows as a (work) day?

Background: 

When start date and SLA number are entered the due date automatically updates using a work day formula.