How to add Month in Calculated Column in SharePoint Online?
To add additional Months to a date in SharePoint calculated column, you should make sure that you are using the
Date() function with a colon (,) instead of semicolon (;) like the below formula.
The output should look like
Also, make sure that the
Month Column is set as below
- The column data type is Number.
- The number of decimal places is set to 0.
Besides that make sure that the returned calculated column is set to
Date and Time data type.
Date Only format.
Read also, Supported and Unsupported Columns In SharePoint Calculated Column Formula