Skip to main content
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. 

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}
),
""
)

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? 

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.

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. 

Reply


Terms & Conditions