MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.



Posted by Brenda on February 13, 2002 8:55 AM

Addition question to 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 this the answer to your last question about retaining the date.....(ctrl-:)...? how did it work......