Current Date and Time in Google Sheets


You can get the current date and time into your spreadsheet cell using one of various built-in functions.

NOW() will enter the date and time every time the spreadsheet is recalculated. If you just want the date part, use TODAY().

If you want the date and time updated automatically, rather than on recalculation, Google drive offers a function GOOGLECLOCK() that will do this for you, updating the time in the cell once per minute, each time triggering a recalculation of your spreadsheet.