View Single Post
  #4   Report Post  
Gordon
 
Posts: n/a
Default

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.