Formula to calculate next month

[Grepees]

Hello Guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Is there a formula to calculate next month? In A1 I have a date set as 08/07/2011. In cell A2, I am only interested in the Month in cell A1 so I pull in my formula as “=TEXT(A1,"mmmm")” which pulls in the month of August. In cell A3, I want to write a formula that would reference Cell A2 and pull in September. Any ideas how I can do that? Thanks in advance you all. <o></o>

 

[njimack]

A2=A1 (formatted as "mmm")
A3 = DATE(YEAR(A2),MONTH(A2)+1,1) (formatted as "mmm")

 

[pgc01]

Also

A2: =A1
A3: =EOMONTH(A1,1)

both formatted as "mmmm"

 

[Peter_SSs]

Seems to me from your A2 formula that you actually want the month as text, rather than a date just formatted that way? If so, perhaps this adaptation of PGC's formula:
=TEXT(EOMONTH(A1,1),"mmmm")

.. or if you have an older Excel version and don't have Analysis ToolPak installed/activated:
=TEXT(A1-DAY(A1)+32,"mmmm")

 

[markmzz]

Maybe this way:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: center;;">8/7/2011</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;;">August</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;;">September</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;;">October</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;;">November</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;;">December</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;;">**************</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A2</th><td style="text-align:left">=TEXT(<font color="Blue">DATE(<font color="Red">YEAR(<font color="Green">A$1</font>),MONTH(<font color="Green">A$1</font>)+ROW(<font color="Green">A2</font>)-ROW(<font color="Green">A$2</font>),DAY(<font color="Green">A$1</font>)</font>),"mmmm"</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[Scott Huish]

=(MONTH(A2)+1)*29
Format as mmmm

 

[T. Valko]

Hello Guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Is there a formula to calculate next month? In A1 I have a date set as 08/07/2011. In cell A2, I am only interested in the Month in cell A1 so I pull in my formula as “=TEXT(A1,"mmmm")” which pulls in the month of August. In cell A3, I want to write a formula that would reference Cell A2 and pull in September. Any ideas how I can do that? Thanks in advance you all. <o></o>

Yet another one...

=TEXT(EOMONTH(A1,1),"mmmm")

Note that the EOMONTH function requires the Analysis ToolPak
add-in be installed if you're using a version of Excel prior to
Excel 2007. If you enter the formula and get a #NAME?
error look in Excel help for the EOMONTH function. It'll tell you
how to fix the problem.

 

[Rick Rothstein]

I'm pretty sure this non-Analysis-ToolPak formula works...

=TEXT(31*MONTH(A1)+1,"mmmm")

 

[Peter_SSs]

Yet another one...

=TEXT(EOMONTH(A1,1),"mmmm")

Looks remarkably similar to one in post #4

 

[barry houdini]

Have we done this one, yet?

=TEXT((A2&1)+31,"mmmm")

assumes A2 has the month as text as per first post