Date Field

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!
 
B

Bob Phillips

=TODAY()

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
T

Tim Otero

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.
 
Top