MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date problem


Posted by Lenny on April 25, 2001 8:01 PM

I am trying to fill a column, say column A with dates.
When I put the Date function in A1, how can i make the
following rows in the column increment the date by 1.

Example:

5-01-2001
5-02-2001
5-03-2001


Posted by Dave Hawley on April 25, 2001 8:25 PM


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

Posted by Kevin James on April 25, 2001 10:00 PM

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.)

Posted by Dave Hawley on April 25, 2001 10:16 PM

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

Posted by Kevin James on April 25, 2001 10:25 PM

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!)

Posted by Lenny on April 26, 2001 2:09 AM

Thanks

Thanks for the help, works like a charm