Add Days in SharePoint Calculated Column

Question

In SharePoint Online, I have lists with two fields Created Date, SLA days, How can I add days to SharePoint calculated field to the the created date field as below:

= DateAdd("d", [SLA], [Created])

I tried the above formula but it returns "the formula contains syntax error or not supported"

Answer 1

How to add days to date in SharePoint Calculated Column?

In your calculated column formula, try to do the following:

1- Add the Date field, then type +, then add the number field.
2. In the data type returned by this formula, select "Date and Time"
3. Select "Date Only" as below

Output

See Also

• Calculate MONTH in SharePoint calculated column
• Supported and Unsupported Columns In SharePoint Calculated Column Formula