macro for date to auto populate

[kingtut]

Hi,

I would like to set up a macro that will do the following.

When a date is entered into A6, I need any other cell of my choosing, to automatically increment the date by month values, and

with this excecuted, i need another cell to of my choosing, to automatically increment the date by month values yet again...

[Bryan Hessey]

Hi,

I would like to set up a macro that will do the following.

When a date is entered into A6, I need any other cell of my choosing, to automatically increment the date by month values, and

with this excecuted, i need another cell to of my choosing, to automatically increment the date by month values yet again...

Hi,

to increment by 1 month, set the formula as

=DATE(YEAR(A6),MONTH(A6)+1,DAY(A6))

adjust A1 to the cell of the date you are incrementing.

hth
---
added, note, if you seriously want those as Macros then make two macros and set the code to

Please Login or Register  to view this content.

and then set Shortcut keys for the pair.

Select the cell and trigger the shortcut as required.

---