How do I create a range of months in Excel?
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
|