Date Macro

S

something.rotten

I can't seem to get this sorted out right but what I need to do is have
a macro that isnerts the date into a document as text. At the moment
I'm using =NOW() and =NOW()+7 for the two dates, but that of course
updates everytime I open or modify the spreadsheet.

Any idea where I can go for this? I haven't done any VB in a while and
forget my way around, so a website or such would be fine.

The macro would be run when a new document is made from the template.

Cheers
~Chris
 
A

Ardus Petus

Just type Ctrl+; (Ctrl and semicolon). That will insert today's date.
In second cell, enter: =A1+7

HTH
 
Top