Adding one day to a date in Excel office 365

Question

I created a formula to add one day to a date in column A. Works well however I need to keep the calendar correct. For example I want to add one day to February 28. The formula returned February 29 when this was not a leap year and should have returned March 1.

detlef_lewin · Answer

saramj430&nbsp;What year would that be?And can you provide a sample workbook with the formula to verify the problem?&nbsp;

twifoo · Answer

The year of the date in Column A might be a leap year but such date is formatted as mmmm dd.

sergeibaklan · Answer

saramj430&nbsp;, interesting, the formula is like =A1+1 or that's something much more complicated

Forum Discussion

Adding one day to a date in Excel office 365

3 Replies

Resources