Beginner
Date & Time
NOW
Returns the current date and time, and updates automatically whenever the sheet recalculates.
Compatibility: All Excel versions
Syntax
=NOW()
Example
=NOW()
When to Use It
Use NOW when you need a timestamp that includes the time of day, not just the date — e.g. logging exactly when a row was last updated.