Feb 20 2020 06:22 AM
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?
Feb 20 2020 02:59 PM
Feb 20 2020 03:00 PM
Feb 20 2020 03:02 PM