![Date and time function examples in Google docs](/sites/default/files/styles/thumbnail/public/2020-01/thumbnail_0.png?itok=DFmC-nca)
Tutorial
Jan 18 2020
Instead of entering in the current date and time manually into your spreadsheet, you can use a function to display the current date and time. This will automatically update every time a cell value changes.
Function syntax
Display the current date and time:
=NOW()
Display the current date, without the time
=TODAY()
Examples
Note that the date and time values are only updated when a cell value on the sheet is update.
Related tutorials
Tutorial
Jan 18 2020