Add exactly 1 Month to Start Date in Sharpoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1184548%22%20slang%3D%22en-US%22%3EAdd%20exactly%201%20Month%20to%20Start%20Date%20in%20Sharpoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1184548%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20any%20know%20another%20formula%20to%20add%20exactly%201%20month%20to%20the%20start%20date%20in%20Sharepoint%3F%20The%20Date%20-%20Year%20-%20Month%20-%20Day%20formula%20does%20not%20trigger%20a%20February%20month%20for%202020%20dates%201%2F29%2C%201%2F30%20and%201%2F31%20--%20instead%20it%20gives%20a%20March%201%20date.%20I%20understand%20that%20February%20usually%20has%2028%20days%20and%2029%20days%20this%20year%20due%20to%20Leap%20Year.%20Formula%20%3CSPAN%3E%3DDATE(YEAR(%5B1%2F29%2F2020%5D)%2CMONTH(%5B1%2F29%2F2020%5D)%2B1%2CDAY(%5B1%2F29%2F2020%5D))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20EDate%20formula%20does%20not%20work%20in%20Sharepoint%20either.%20Any%20other%20ideas%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1184548%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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 -- instead it gives a March 1 date. I understand that February usually has 28 days and 29 days this year due to Leap Year. Formula =DATE(YEAR([1/29/2020]),MONTH([1/29/2020])+1,DAY([1/29/2020]))

 

The EDate formula does not work in Sharepoint either. Any other ideas? 

3 Replies
Highlighted
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]))
Highlighted
But then you have the issue of December lol.... hmmm.
Highlighted
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]))