update date
 

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

update date
 

=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

update date
 

In a cell enter:
=TODAY()
--
Gary''s Student - gsnu200828


"djolienoc" wrote:

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

update date
 

Use the function TODAY()
--
David Biddulph

"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