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.