True. I should have mentioned that. Thanks Peo.

Maybe I should have made that ...

For text:
=TEXT(DATE(YEAR($A$1),MONTH($A$1)+ROW(A1),1),"mmmm")

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:OeJ5$CEVGHA.4952@TK2MSFTNGP09.phx.gbl...
>
> "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
>
>
>