auto complete date

[D]

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

 

[Pete_UK]

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

 

[The Rain]

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.

 

[Gord Dibben]

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 Edit>Fill>Series>Autofill.

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