How to Create a Field That Will Show the Current Time and Date in Google Sheets
If you need to have a field in the Google Sheets table that always displays the current time and date, you can easily do that. Note that the time and date will not update in real time, but only when you close and reopen the document.
Watch our video tutorial where we show you how to create a field that will show the current time and date in Google Sheets, using Windows 10 and Mozilla Firefox.
Video Transcript:
- How to Create a Field That Will Show the Current Time and Date in Google Sheets
- Click on the field where you want to display the current time and date
- Type =now() and press Enter on your keyboard
- We can also create a field that will display only the date. Type =today() and press Enter on your keyboard.
- Each time you open this table the date and time will be updated
Rate:
(No Ratings Yet)
Loading...
