It is in text format. This is for my reviews and it pulls from somewhere
else on the sheet. Would a number/date format be easier to use?

"Zack Barresse" wrote:

Hi Todd,

That really depends if what you have in the cell is a date or text. When
you select a cell in question, what does it say in the Formula Bar? Is it
"June"? Or is a number/date *formatted* to show June (mmmm)?

If it's a date, check out the EOMONTH function from the Analysis Toolpak.

HTH

--
Regards,
Zack Barresse, aka firefytr


"Todd Nelson" wrote in message
...
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"?