SOLVED
Home

Hire DAte add 30

%3CLINGO-SUB%20id%3D%22lingo-sub-582854%22%20slang%3D%22en-US%22%3EHire%20DAte%20add%2030%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-582854%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20date%20cell%20(hire%20date)%20to%20which%20I%20need%20to%20add%2030%20days%20and%20then%20show%20the%20first%20of%20the%20month%20after%20that%20date.%26nbsp%3B%20Not%20sure%20which%20formula%20to%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-582854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-582881%22%20slang%3D%22en-US%22%3ERe%3A%20Hire%20DAte%20add%2030%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-582881%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343977%22%20target%3D%22_blank%22%3E%40gmartineau%3C%2FA%3E%26nbsp%3B%2C%20that%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DEOMONTH(A1%2B30%2C0)%2B1%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583251%22%20slang%3D%22en-US%22%3ERe%3A%20Hire%20DAte%20add%2030%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583251%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthat%20works%20perfectly.%26nbsp%3B%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583266%22%20slang%3D%22en-US%22%3ERe%3A%20Hire%20DAte%20add%2030%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343977%22%20target%3D%22_blank%22%3E%40gmartineau%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
gmartineau
New Contributor

I have a date cell (hire date) to which I need to add 30 days and then show the first of the month after that date.  Not sure which formula to use.

3 Replies
Solution

@gmartineau , that could be

=EOMONTH(A1+30,0)+1

@Sergei Baklan that works perfectly.  Thank you

@gmartineau , you are welcome

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