Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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!

Re: Adding Automatic Date to Spreadsheet

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


Re: Adding Automatic Date to Spreadsheet

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?


Re: Adding Automatic Date to Spreadsheet

Posted by Jim on February 13, 2002 9:58 AM
Use control colon (Ctrl-:) instead of using a formula.


Re: Adding Automatic Date to Spreadsheet

Posted by Mike Golding on February 13, 2002 9:21 PM


Re: Adding Automatic Date to Spreadsheet

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

Re: Adding Automatic Date to Spreadsheet

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......



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.