I need a column that contains the "Estimated SLA Completion Date", which is calculated by "SLA" and "Date Priority Set". SLA can equal 3 Days, 5 Days, 10 Days, 30 Days or 60 Days. Date Priority Set would be mm/dd/yyyy For Example if Date Priority Set is 04/01/2015, and SLA is 3 days then Estimated SLA Completion Date would be 04/04/2015. I am getting hung up because the SLA actually has the word "Days" after each number. So I think I need a nested IF statement.

1 Answer 1


Create a calculated column and set the return type as Date only.

Add the below formula:

=[Date Priority Set]+LEFT([SLA],LEN([SLA])-5)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.