cell to return current date?

  • Thread starter Thread starter jwcater
  • Start date Start date
J

jwcater

How do I get a cell to return the current date in Excel 2000? I want a
particular spreadsheet to display the current date in a field each time
I open that particular file. Can this be done in Excel 2000?

Thanks,
John
 
John,

Just use this formula

=TODAY()

and format as a date.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top