On Fri, 5 Aug 2005 14:09:03 -0700, "Todd Nelson"
wrote:
Is there a formula that would read the previous cell and insert the following
month? Ex. Prev Cell is "June" the next cell would read "July"?
Assuming the content is text and is in A1, then:
=TEXT(DATE(2005,MONTH(DATEVALUE("1 "&A1&" 2005"))+1,1),"mmmm")
should return what you want in text format.
--ron
|