| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 49918 | 2004-10-04 23:39:00 | Excel TODAY() | Rob99 (151) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 278311 | 2004-10-04 23:39:00 | I want to create a simple invoice template, what is the best method to insert todays date and save it. ie. when the file not the template is opened another day the date does not update. eg. Type out invoice today() - inserts todays date 5/10/04 open that file another day and have the date still read 5/10/04. I have locked the cell and protected the sheet and it does not work. Is there something else I could use? Cheers Rob |
Rob99 (151) | ||
| 278312 | 2004-10-05 00:09:00 | =Today() will always be the current day. You need to copy the =Today() cell and PasteSpecial as Values to another cell to fix the date in place. This can be done automatically via macro code by capturing the BeforeSaveEvent. If this appeals, the code and method can be supplied. |
Russell D (18) | ||
| 278313 | 2004-10-05 00:40:00 | Thanks for the tip, I enjoy nutting things out so I will have a go, and post back if I need more help. | Rob99 (151) | ||
| 278314 | 2004-10-05 03:46:00 | Rob, you could try @date(4,10,5) comes up as 5/10/04. Les 3 |
leshibbard (873) | ||
| 1 | |||||