update date

[djolienoc]

when i open a spreadsheet how do i get the date to auto update.

ex. I open spreadsheet once daily-each day i open spreadsheet i want the
spreadsheet to update to today's date

 

[Harald Staff]

=TODAY()
in the desired date cell.

HTH. Best wishes Harald

 

[Gary''s Student]

In a cell enter:
=TODAY()

 

[David Biddulph]

Use the function TODAY()