I need a macro code to change the current date

[Sheree]

Hi All,

I need a macro code to change the current date in a doc to 7 days later.


Sheree

 

[tactps]

Where is this date? Is it in the header? In a cell?

 

[Sheree]

In a cell (2C), I need to add this date change code to a macro

 

[tactps]

This will do it.

sub changedate()
[C2] = [C2]+7
end sub

 

[Sheree]

Thank you so much it worked!!!

 

[Sheree]

Thank you so much it worked!!!

 

[Sheree]

Thank you so much it worked!!!