Sharepoint: How to get future dates with calculated columns

Published on Author peter.stilgoe

Create a calculated column to set the date as the 28th of the month the item was created:

=TEXT(DATE(YEAR(Created),MONTH(Created),"28"),"DD-MM-YYYY")

Create a calculated column to set the date as the 1st of the following month form the date the item was create:

=TEXT(DATE(YEAR(Created),MONTH(Created)+1,"01"),"DD-MM-YYYY")