=TODAY()
in the desired date cell.

HTH. Best wishes Harald

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