# Add exactly 1 Month to Start Date in Sharpoint

Occasional Visitor

# 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 -- 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

# Re: Add exactly 1 Month to Start Date in Sharpoint

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]))

# Re: Add exactly 1 Month to Start Date in Sharpoint

But then you have the issue of December lol.... hmmm.

# Re: Add exactly 1 Month to Start Date in Sharpoint

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]))