"Zack Barresse" <firefytrNO@SPAMvbaexpress.com> wrote in message
news:evZ$WAEVGHA.6084@TK2MSFTNGP14.phx.gbl...
> Hi there,
>
> It depends on what is in the cell as a value. If it is a date, then you
> can use something like this...
>
> For text:
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,1),"mmmm")

will only work in the first cell then it will return a value error since the
second formula will be working with text and YEAR, MONTH and DAY will throw
an error for text



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com