Hi
in A1 enter
=DATE(2002,ROW()+1,0)
and copy this down
--
Regards
Frank Kabel
Frankfurt, Germany
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
|