auto complete date
 

hello, I need to autocomplete the date when I enter a date such as April 19
2008. i need it to copy down as many as 36 months.
This seem simple but i am having problems doing it.
thanks

auto complete date
 

Try something like this:

enter your date in A1, and put this formula in A2:

=IF(A1="","",DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)))

Format A2 as a date, then copy that down to A36 - it will increment
the month on each row.

Hope this helps.

Pete

On Apr 19, 11:38*pm, D wrote:
hello, I need to autocomplete the date when I enter a date such as April 19
2008. i need it to copy down as many as 36 months.
This seem simple but i am having problems doing it.
thanks

auto complete date
 

Use the cell filler ( at the right bottom part of each cell ).
You can either click it and drag it down or
right click it and drag it down for more menu options.
--
Can''''t hear the Rain ?
Then listen to it.


"D" wrote:

hello, I need to autocomplete the date when I enter a date such as April 19
2008. i need it to copy down as many as 36 months.
This seem simple but i am having problems doing it.
thanks

auto complete date
 

Unless you have set up formulas in the cells to add the dates nothing will
happen if you simply enter a date in A1

I would enter the date in A1 then in the namebox type in A1:A1150 and ENTER.

Then EditFillSeriesAutofill.

Or simply enter the date in A1 and drag/copy down as far as you wish.

The formula method woulkd go like this.

In A2 enter =IF(A1="","",A1+1)

Copy that down a great whack of rows.

Then enter a date in A1 to fill.

Or you could use event code or a macro with an inputbox to designate how many
months to copy down.


Gord Dibben MS Excel MVP


On Sat, 19 Apr 2008 15:38:00 -0700, D wrote:

hello, I need to autocomplete the date when I enter a date such as April 19
2008. i need it to copy down as many as 36 months.
This seem simple but i am having problems doing it.
thanks