| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you keep the date using =TODAY() from changing?
Is there a way of using the =TODAY() function and lock that date, so it
doesn't change if I were to open it on another day? |
|
#2
|
|||
|
|||
|
Hi
see http://www.mcgimpsey.com/excel/timestamp.html Also Ctrl ; will automatically put today's date in the cell "Chaneyt" wrote: Is there a way of using the =TODAY() function and lock that date, so it doesn't change if I were to open it on another day? |
|
#3
|
|||
|
|||
|
Hi
see: http://www.mcgimpsey.com/excel/timestamp.html -- Regards Frank Kabel Frankfurt, Germany Chaneyt wrote: Is there a way of using the =TODAY() function and lock that date, so it doesn't change if I were to open it on another day? |
|
#4
|
|||
|
|||
|
Not with a formula, now. If you want to insert a static date, you can do it
fairly easily with the keyboard shortcut CTRL+; On Fri, 29 Oct 2004 13:24:02 -0700, "Chaneyt" wrote: Is there a way of using the =TODAY() function and lock that date, so it doesn't change if I were to open it on another day? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
