Date Entries

[Gordon]

I am trying to enter a date function so that when the
excel document is enetered it shows the date as it should
for the day. E.g. - I enter the spreadsheet on the 19th
September and in the selected cell it correctly shows
19/09/2003. I enter the spreadsheet on the 20th
September and the same selected cell shows the 20/09/2003.

Please help!!

 

[Robert Rosenberg]

If you're not concerned with the time of day, use the TODAY() function
instead of NOW().
__________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP-Excel