How to Use NOW Function in Excel: Get Current Date and Time
Use the
NOW() function in Excel to get the current date and time. It updates automatically whenever the worksheet recalculates or opens.Syntax
The NOW() function has no arguments. Just type =NOW() in a cell to get the current date and time.
- NOW(): Returns the current date and time from your computer's clock.
excel
=NOW()
Output
4/27/2024 14:35 (example output depends on current date and time)
Example
This example shows how to use NOW() to display the current date and time in a cell. The value updates when you open or recalculate the sheet.
excel
=NOW()
Output
4/27/2024 14:35 (example output depends on current date and time)
Common Pitfalls
People often expect NOW() to update continuously like a clock, but it only updates when the sheet recalculates or opens. To force update, press F9 to recalculate.
Also, if you want only the date without time, use =TODAY() instead.
excel
=NOW() <em>(updates on recalculation)</em> =TODAY() <em>(date only, no time)</em>
Quick Reference
| Function | Description | Example Output |
|---|---|---|
| NOW() | Returns current date and time | 4/27/2024 14:35 |
| TODAY() | Returns current date only | 4/27/2024 |
Key Takeaways
Use =NOW() to get the current date and time that updates on sheet recalculation.
NOW() has no arguments; just type =NOW() in a cell.
Press F9 to manually refresh the NOW() value if needed.
Use =TODAY() if you only want the current date without time.
NOW() output depends on your computer's clock and regional date/time settings.