One way, assume you copy accross, put first date manually in A1, e.g. 01/31/04
in B1 put

=DATE(YEAR(A1),MONTH(A1)+2,0)

copy across as long as needed, then select all dates and use a custom format
of

mmm dd yyyy


Regards,

Peo Sjoblom

"Mo" wrote:

I need to create a list of months (at monthly intervals) as at the last day
of each month - Jan 31 2002, Feb 28 2002, March 31 2002 etc.. Once I have
this I shall give to a name for use in a combo box. I cannot get FILL -
Series to work which I think is what is needed in this case.

Any help would be much appreciated.

Thanks