Enter
01/01/01
Into A1
And
01/02/01
Into A3

You could custom format those 2 cells to display exactly what you wish.

Then, select A1 to A4.
Click on the fill handle of that 4 cell selection, and copy down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"viper" wrote in message
...
I would like to know how to put a date in this format 01/01/01 on A1 and I
would like excel to to change the date on A3 to 01/02/01 and so on and so
forth. how do I do it. for a whole year or two.

I would like to know how to put a date in this format 01/01/01 on A1 and I
would like excel to to change the date on A3 to 01/02/01 and so on and so
forth. how do I do it. for a whole year or two.