date in spreadsheet

Kevin · Nov 6, 2004

What is the formula so that the spreadsheet displays todays date and it
changes automatically ?

Nick B · Nov 6, 2004

You can use:
=now() for date and time
or
=today() for date

Gord Dibben · Nov 6, 2004

Kevin

=TODAY()

Gord Dibben Excel MVP