Forum Discussion
SCheng1216
Feb 20, 2020Copper Contributor
Add exactly 1 Month to Start Date in Sharpoint
Does any know another formula to add exactly 1 month to the start date in Sharepoint? The Date - Year - Month - Day formula does not trigger a February month for 2020 dates 1/29, 1/30 and 1/31 -- ins...
Feb 20, 2020
But then you have the issue of December lol.... hmmm.
Feb 20, 2020
Maybe this?
=DATE(YEAR([1/29/2020]),IF(VALUE(MONTH([1/29/2020]))+1 = 13,1,VALUE(MONTH([1/29/2020]))+1),DAY([1/29/2020]))
=DATE(YEAR([1/29/2020]),IF(VALUE(MONTH([1/29/2020]))+1 = 13,1,VALUE(MONTH([1/29/2020]))+1),DAY([1/29/2020]))