Dumb Question About Time and date

  • Thread starter Thread starter mdginzo
  • Start date Start date
M

mdginzo

It's a dumb question because I used to be a whiz at Excel, but in the last
three years in a new job forgot so much of it. Here is the deal: how do I
put a formula in a cell that will show the current time or the current date?
I used to know how to do this, but can't figure it out now. I am using
Excel 97. Thank you.
 
The formula =NOW() will return the current date and time. The formula
=TODAY() will return the current date without the time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top