date in spreadsheet

Guest · Nov 6, 2004

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

Guest · 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

If/Then Formula Using Dates	1	Dec 3, 2011
if/then insert date but don't want automatic updates	7	Aug 17, 2009
How do count a cell range that include all dates prior to today?	3	Aug 19, 2009
Total formula	1	Aug 3, 2012
Excel Excel due and overdue date colours	2	Sep 6, 2018
Cell shows the last typed text, no matter where it is typed	0	Feb 25, 2020
Don't Update Function	1	Sep 23, 2008
Selecting Date	7	Jan 4, 2010

Ask a Question