Date Field
 

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!

Date Field
 

=TODAY()

--
HTH

Bob

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

"karenbeth24" wrote in message
...
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!

Date Field
 

karenbeth24 wrote:
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!

Sure, use the formula

=TODAY()

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

Date Field
 

Try

=Today()

Mike

"karenbeth24" wrote:

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!