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.
=DATE(YEAR(Start),MONTH(Start)+month,DAY(Start))
The output should look like
![add a month to a calculated field in SharePoint Online](https://debug.to/?qa=blob&qa_blobid=11692901100014875911)
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.
![month column in sharepoint](https://debug.to/?qa=blob&qa_blobid=7304695518068098817)
Besides that make sure that the returned calculated column is set to
Date and Time
data type.
Date Only
format.
![Month Add in SharePoint calculated column](https://debug.to/?qa=blob&qa_blobid=15177029936272921930)
Read also, Supported and Unsupported Columns In SharePoint Calculated Column Formula