You could use something like this in A1:
=date(2010,row(),1)

=row() will return 1 if the formula is in row 1. Adjust it to start where you like:
=date(2010,row()-12,1)
If you start in row 13.

Then copy down (and convert to values????).

Then give the range a nice number format: mmmm yyyy

It'll still be the first of each month. You'll see it in the formula bar, but
you won't see it in the cell.

On 04/01/2011 08:53, dido22 wrote:
Can someone please help me generate a list of dates in a column. I just need
month and year, so Jan 2010, Feb 2010, Mar 2010 .....etc. No days or dates.
Thanks KK

--
Dave Peterson