auto date input?

[ashleee1992]

Hi,

can i make excel automatically date the squares, like, 1/1/2000 in a1, 2/1/2000 in a2, 3/1/2000 in a3 and so on..

i thought it'd be pretty simple, apparently not..

can you guys help? thanks

 

[wigi]

Put the begin date in cell A1, and drag the fill handle (small cross in the lower right corner of the cell) to as far as you need. Release the mouse button and you're done.

 

[ashleee1992]

thanks so so much! :D