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