Do you want current month in A1 and coming month in B1 and so on? In A1 put

=TEXT(TODAY(),"mmm")

in B1

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+COLUMNS($A $1:A1),1),"mmm")

copy across


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Susan" wrote in message
...
In a spreadsheet, I am trying to populate a cell with the next month. For
example, if cell B1 = Jan., I want C1 to become February (and so on
depending
upon the current month.

Any hints/help. I was using the lookup function, but it doesn't always
return the correct month.