Set date in cell 2 weeks from current date

[dutchdog]

Hi, I would like to set a date in a cell 2 weeks ahead from the current date based on systemtime.


So if I open document today (17/5/2011), cell would display 31/5/2011

Is there an easy sollution to this. I incorporate it in a macro that I run, so date can be 5/5/2011 and then run macro, checks current systemdate and sets date 2 weeks ahead in those cells I want.

Or a macro that does this when one opens the document.

 

[MrKowz]

perhaps:

Worksheet formula:
=TODAY()+14

VBA:
=Date+14

 

[dutchdog]

Thanks, this forum is realy helpfull for excell noobs like myself.