How to automatically increase the "day" on date.

[Guest]

I would like to insert a range of dates (mm/dd/yyyy), increasing the "day" by
1.
11/01/2004 11/02/2004 11/03/2004........
I tried the the example from Help, it works but customer would like to type
the new date in first cell and the other cells in the range would
automatically update.

Thank you
ramo

 

[Frank Kabel]

Hi
in B1 enter
=A1+1
and format as date

 

[Guest]

Type in the date in the first cell then grab the fill handle and drag down as
many cells as you need dates for and release at the last cell. It should
automatically increase your date by "1" in each cell.