Date Field

  • Thread starter Thread starter karenbeth24
  • Start date Start date
K

karenbeth24

Is it possible to insert a date field into an Excel spreadsheet like you can
in Word? A date field that would update to the current date each time you
opened the spreadsheet?

Thanks!
 
=TODAY()

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
karenbeth24 said:
Is it possible to insert a date field into an Excel spreadsheet like you can
in Word? A date field that would update to the current date each time you
opened the spreadsheet?

Thanks!
Click to expand...

Sure, use the formula

=TODAY()

Keep in mind, however, this will update each time you open the sheet.
 
Back
Top