Display today’s date AND time in a cell
- Select the cell where the date needs to be displayed
- Enter the formula
- Press Enter
Today’s date and time will be displayed in the cell and update every time the file is opened.
The TODAY() function which displays just the date.