MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Randy on January 22, 2002 8:09 AM

Is there a way to make an excel document default the current date in a cell.

Posted by Steve Hartman on January 22, 2002 8:18 AM

put =today() in the cell and format cell for date. Everytime you open the worksheet and whenever it is recalculated you will get the current date.

Posted by Stephanie Roberts on January 23, 2002 2:50 AM

Having used the =today(), I want to be able to refer to the cell with that function in and then don't want the date in the new cell to change when the system date changes to the following day. What do I do please?

I have tried to use the =text function but cannot make that work either.


Posted by Steve Hartman on January 23, 2002 7:59 AM

I think any formula reference you make to the cell with =TODAY() will change when the day changes. You can manually copy the date by using EDIT > Paste Special > and checking value.

Could you give a little more info on what youo are trying to do?