MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can you format a cell to have it display the current date

Posted by Patrick on August 27, 2001 5:45 PM

I was wondering if there is some way to link a cell
so that it displays the current date whenever it is opened.

Posted by Richard S on August 27, 2001 6:20 PM

=NOW(), format dd/mm/yyyy

Posted by Patrick on August 29, 2001 10:52 AM

Re: =NOW(), format dd/mm/yyyy

thank you