Date problem

Hi Lenny

Select the date in cell A1.
Right click on the fill handle (small black square bottom right of cell)
Now with the right mouse buttun held down, drag down.
When you get to the row you want release the Mouse button and take you pick.

Dave

OzGrid Business Applications

Various ways to skin a cat

Another method will allow you to change only the date in cell A1 and allow all the subsequent dates to update correspondingly.

In cell A1 enter the date. (If you get an odd looking number, format the cell as a date.)
Then, in cells A2 enter =A1+1.
Copy cell A2 down to the last row you want to use, and, vouala, you've got it.

(Sorry for my attempt at French. Fact is, I have no clue how to spell it or even what it really means.)

MeeeeOOOOWWWWWWWW!!!!!!!

Bonjour Messieur Kevin

I too cannot speak French :o)

I though about suggesting the formula method also, but didn't know if icrement was to be by Month or Day ?
In which case the formula could be:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

...Or use:
=EDATE(A1,1)
If the analysis toolpak is installed.

Dave

OzGrid Business Applications

Re: MeeeeOOOOWWWWWWWW!!!!!!! Hey, my cat is just about that demanding.

I realize this is a bit out of decorum, but what the heck.

Have a great day. I'm in California, USA and its beddy-bye time for me.

Adios, Hasta Mannana.
(whow, I'm multilingual!)

Thanks

Thanks for the help, works like a charm