<div>
=EOMONTH(a1,1)<br />
<br />
if A1 has the date such as Jan 1 then B1 will have Feb 1<br />
<br />
I meant to say put the formula in B1
</div>


<div>
Hi Edward, thanks for the quick reply. Please note, am getting an #value issue. I have changed the format to &quot;mmm&quot;. And please note, i use Jan- Dec in cell A1 rather than Jan 1 or Feb 1, thanks
</div>


<div>
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.
</div>


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


<div>
Thanks Norie. Formula is working. Am getting the desired result with the above formula.
</div>


<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Accept: Norie (<a href="https:#a42108138" rel="ugc">https:#a42108138</a>)<br />
<br />
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.<br />
<br />
broomee9<br />
Experts-Exchange Cleanup Volunteer
</div>


<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Excel formula to return next month when i select current month

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.