Gordon

FWIW what you suggests works for any year except a leap year e.g. when
you need to enter 29 Feb 2004.


~~~~~~

Regards.

Gerry

~~~~~~~~~~~~~~~~~~~~~~~~
FCA

Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~



"Gordon" wrote in message
...
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

In the first cell type "31 Jan 2002", in the second type "28 Feb 2002"
(both without the quotes). Highlight both cells, and then drag for as
far as you want to go.