Adding Automatic Date to Spreadsheet
Posted by Ryan on February 13, 2002 7:32 AM
I need to know how to have my spreadsheet automatically post the current date. Please help-its driving me crazy!
Posted by Richard Winfield on February 13, 2002 8:39 AM
add the following formula to the cell you want the date to appear in.
=today()
Rick
Posted by Brenda on February 13, 2002 8:55 AM
Addition question to this....how do it get it to retain the date. Say I put that formula in a cell and when I go back to that sheet tomorrow it changes it to the current date. How do I get it to hold the date that was put there to begin with?
Posted by Jim on February 13, 2002 9:58 AM
Use control colon (Ctrl-:) instead of using a formula.
Posted by Mike Golding on February 13, 2002 9:21 PM
Posted by Mike Golding on February 13, 2002 9:23 PM
I'm very interested in the replies. I wonder if it can be done with a Macro??
Thanks Mike
Posted by jim gregory on April 20, 2002 5:26 PM
jim...is this the answer to your last question about retaining the date.....(ctrl-:)...? how did it work......
