Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Automatic, Non-Updating Date Stamp
I use an Excel invoice to bill clients.
Currently I have an Invoice Date field which is populated by the =TODAY() function. That's good. However, if I open the spreadsheet down the road and accidentally recalculate, the Invoice Date field is updated with the current date. That's not so good. Is there a simple macro I can use that Inserts the date when the document is created and then terminates? Something, I guess, that calls the TODAY() function and then pops the resulting date value into the appropriate cell. I know I can just use CTRL+; to insert the date manually but I'm shooting for *fewer* things that I can potentially forget when invoicing. Thanks, KZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
insert the last date when the file was modifie | Excel Discussion (Misc queries) | |||
Excel 2003: can I insert a "last edited" date function? | Excel Worksheet Functions | |||
Automatic updating of Conditional Formats using dates | Excel Worksheet Functions | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) |