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
6k views
in SharePoint Online by 1 1 2

I have a calculation problem in the sharepoint calculated column, and I can't add months to a date in a calculated column

=DATE(YEAR([Start]);MONTH([Start])+[month];DAY([Start]))

1 Answer

0 like 0 dislike
by 163 204 403

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

Also, make sure that the Month Column is set as below

  1. The column data type is Number.
  2. The number of decimal places is set to 0.

month column in sharepoint

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

Read also, Supported and Unsupported Columns In SharePoint Calculated Column Formula

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