Date Range
Posted by lucky on January 30, 2002 7:19 AM
Hi all!
I have 2 dates entered in 2 cells on sheet1 e.g
a1 = 01/05/1999
a2 = 01/09/1999
and I wish to automatically produce a monthly range on a separate sheet that begins with the date in sheet1!a1 and ends with the date in sheet1!a2, i.e. resulting in;
Sheet2
a1 = 01/05/1999
a2 = 01/06/1999
a3 = 01/07/1999
a4 = 01/08/1999
a5 = 01/09/1999
the date range will vary from a few months to up to 24 months.
Any ideas??
Cheers!