starysummernight
New member
- Nov 11, 2010
- 1
- 0
- 1
...time/date functions like TODAY () an? If you keep your computers clock set correctly I know that you can use functions like TODAY () and NOW () to get the current time and date from the system clock, but once you get this valuable information how can you keep it? What I mean is, if you have more than one occurrence of NOW on a spreadsheet, each time you execute the command is updated erasing the old values. Is there a way you can preserve the results that you get from these functions either by copying the results somewhere else or by turning the results into text?
For example I have a spreadsheet where I want the current date to be automatically recorded each time I use the street. So when I use the sheet on Monday I want that date to be recorded from the system clock. The next day when I go to use the sheet, I want that date recorded, etc. but if I use the now function or the today function, each entry will be automatically converted to the current time or day instead of preserving the value previously recorded… How can I make it so that these values are usable, and not get erased each time they are executed? Is there somewhere else I can store the old results or preserve it? Or do it some other way? So that I can get the following result from the system clock:
Column 1 row one (yesterday's date)
column 1 row two (today's date)
column 1 row three (the next days date) etc.
For example I have a spreadsheet where I want the current date to be automatically recorded each time I use the street. So when I use the sheet on Monday I want that date to be recorded from the system clock. The next day when I go to use the sheet, I want that date recorded, etc. but if I use the now function or the today function, each entry will be automatically converted to the current time or day instead of preserving the value previously recorded… How can I make it so that these values are usable, and not get erased each time they are executed? Is there somewhere else I can store the old results or preserve it? Or do it some other way? So that I can get the following result from the system clock:
Column 1 row one (yesterday's date)
column 1 row two (today's date)
column 1 row three (the next days date) etc.