Home

Excel formula to calculate a date.

%3CLINGO-SUB%20id%3D%22lingo-sub-449876%22%20slang%3D%22en-US%22%3EExcel%20formula%20to%20calculate%20a%20date.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449876%22%20slang%3D%22en-US%22%3EIs%20there%20an%20Excel%20formula%20that%20will%20allow%20you%20to%20enter%20a%20date%20in%201%20box%20and%20it%20will%20calculate%20a%20fixed%20period%20of%20time.%20For%20example%20if%20I%20entered%2031%2F12%2F2019%20in%20one%20cell%20it%20would%20return%20an%20answer%20of%209%20months%20later%2030%2F09%2F2020%20%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-449876%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-449915%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20to%20calculate%20a%20date.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449915%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320616%22%20target%3D%22_blank%22%3E%40Chuftybadge%3C%2FA%3E%26nbsp%3B%2C%20it%20could%20be%2C%20for%20example%2C%20EDATE%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fedate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fedate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Chuftybadge
Occasional Visitor
Is there an Excel formula that will allow you to enter a date in 1 box and it will calculate a fixed period of time. For example if I entered 31/12/2019 in one cell it would return an answer of 9 months later 30/09/2020 ??
1 Reply
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 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