We help IT Professionals succeed at work.

Excel formula to return next month when i select current month

117 Views
Last Modified: 2017-11-15
Hi, am looking for a simple excel formula to reflect next month when i select any month. For example, if i select Feb in cell A1, in cell B1 should give the result as Mar. Can someone help please.
Comment
Watch Question

Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
=EOMONTH(a1,1)

if A1 has the date such as Jan 1 then B1 will have Feb 1

I meant to say put the formula in B1

Author

Commented:
Hi Edward, thanks for the quick reply. Please note, am getting an #value issue. I have changed the format to "mmm". And please note, i use Jan- Dec in cell A1 rather than Jan 1 or Feb 1, thanks
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
If you just have the month it will give you a #VALUE error. That's why I said you need an actual date. I am pretty sure another expert will chime in with a better solution. If the date is as I posted it will work otherwise you will get the error.
Analyst Assistant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
KoenSDM Mobile
CERTIFIED EXPERT

Commented:
just create a dummy table in your spreadsheet (other sheet, or "off the border") first colum say AA has Jan-DEC, column AB has FEB-JAN
then do a vlookup in your B column:
cell b2 :  =vlookup(a2;aa1:bb12;2;0) will give you the desired result

Author

Commented:
Thanks Norie. Formula is working. Am getting the desired result with the above formula.
TracyVBA Developer
CERTIFIED EXPERT

Commented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Norie (https:#a42108138)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

broomee9
Experts-Exchange Cleanup Volunteer
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.