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>

 

[T. Valko]

Looks remarkably similar to one in post #4

Looks similar but returns a significantly different result.

 

[markmzz]

A modification in the formula that I post:

=TEXT(DATE(YEAR(A$1),MONTH(A$1)+ROW(A2)-ROW(A$2),DAY(1)),"mmmm")

Markmzz

 

[Peter_SSs]

Looks similar but returns a significantly different result.

How so?

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

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

 

[T. Valko]

Also

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

both formatted as "mmmm"

How so?

What the heck!

I don't remember even seeing your post.

My bad.

I thought you were referring to that post by pgc01 which is post #3.

 

[Grepees]

Thank you very much guys. Its amazing the different ways that you can do something. Once again thank you very much!!