Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
in SharePoint Online by 13 17 25

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"

the formula contains syntax error or not supported sharepoint 2019

1 Answer

1 like 0 dislike
by 154 174 350
selected by
Best answer

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

DateAdd in SharePoint Calculated Field


DateAdd function in SharePoint Calculated column

See Also

If you don’t ask, the answer is always NO!