Home

Adding one day to a date in Excel office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-502027%22%20slang%3D%22en-US%22%3EAdding%20one%20day%20to%20a%20date%20in%20Excel%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-502027%22%20slang%3D%22en-US%22%3EI%20created%20a%20formula%20to%20add%20one%20day%20to%20a%20date%20in%20column%20A.%20Works%20well%20however%20I%20need%20to%20keep%20the%20calendar%20correct.%20For%20example%20I%20want%20to%20add%20one%20day%20to%20February%2028.%20The%20formula%20returned%20February%2029%20when%20this%20was%20not%20a%20leap%20year%20and%20should%20have%20returned%20March%201.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-502027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-502120%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20one%20day%20to%20a%20date%20in%20Excel%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-502120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293356%22%20target%3D%22_blank%22%3E%40saramj430%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20year%20would%20that%20be%3F%3C%2FP%3E%3CP%3EAnd%20can%20you%20provide%20a%20sample%20workbook%20with%20the%20formula%20to%20verify%20the%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-504805%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20one%20day%20to%20a%20date%20in%20Excel%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-504805%22%20slang%3D%22en-US%22%3EThe%20year%20of%20the%20date%20in%20Column%20A%20might%20be%20a%20leap%20year%20but%20such%20date%20is%20formatted%20as%20mmmm%20dd.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-505310%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20one%20day%20to%20a%20date%20in%20Excel%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-505310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293356%22%20target%3D%22_blank%22%3E%40saramj430%3C%2FA%3E%26nbsp%3B%2C%20interesting%2C%20the%20formula%20is%20like%20%3DA1%2B1%20or%20that's%20something%20much%20more%20complicated%3C%2FP%3E%3C%2FLINGO-BODY%3E
saramj430
New Contributor
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.
3 Replies

@saramj430 

What year would that be?

And can you provide a sample workbook with the formula to verify the problem?

 

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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies