I want to create acalculated column that takes a date field and sets the value to the date, increased by one day. How can this be done?
If date field value:
calculated result will be:
Suggest some formula to use.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Date columns are essentially numbers starting at 30/12/1899
So besides adding one day, you have to display it as a date again (when using it in a Calculated Column datatype=Text)
=TEXT( [Due Date]+1 , "dd/mm/yyyy" )
Or set the datatype of the Calculated Column to Date
Adding one day correctly counts the new date
outputs january 1st 2016
More Date functions: http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List