How to use the calculated value date in the Link Lists field to find the date + 30 days?

Question

I have a list that I created in Sharepoint, where one of the fields is the date that the user enters. I want to add another field, which is a computed value field, which should be a date provided by the user + 30 days. What formula do I need to go to the calculated value field to achieve this?

Answer 1

Try the following:

• Create a new calculation column
• In the Forumla field, enter the following: = TEXT ([current date column] +30, "yyyy-mm-dd") You can use any date format string that you like instead of "yyyy-mm-dd"
• Enter the date and time data type
• Specify the date and time format "Date only"