asked on

Excel formula to return next month when i select current month

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.

Edward Pamias

=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

kunal dutt

ASKER

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 Pamias

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.

ASKER CERTIFIED SOLUTION

Norie

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Koen

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

kunal dutt

ASKER

Thanks Norie. Formula is working. Am getting the desired result with the above formula.

Tracy

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