Forum Discussion
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...
Take the integer value of Month, so return Month and add 1 to it. So something like this might work? =DATE(YEAR([1/29/2020]),VALUE(MONTH([1/29/2020]))+1,DAY([1/29/2020]))
- But then you have the issue of December lol.... hmmm.
- 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]))