Thread: Entering sequential dates

Hi, I have a simple request.
All I want to do is enter the date, from Column A downwards for as long as I can. Without having to go into each cell to manually enter the date. That is is, each cell progressing to the next date.

Is there a formula that enters the date automatically?

thanks

Hi, I have a simple request.
All I want to do is enter the date, from Column A downwards for as long as I can. Without having to go into each cell to manually enter the date. That is is, each cell progressing to the next date.

Is there a formula that enters the date automatically?

thanks

Enter two consecutive dates, select both cells, and drag the fill handle down as far as you like.

Threads merged.

derdnifferus, please don't post the same question in two forums.

You might want to read the Forum Rules.

sorry about that. I wanted to delete the first one, but didn't think it was possible.

Ah ha! problem solved. Thanks Shg.

You're welcome, and welcome to the forum.

Until you get your feet under you, it will probably be useful for you to remain in the new users forum -- it gives people a sense of the level of help to provide.