NOW
The NOW function returns the current date and time as a serial number.
Syntax
=NOW() About
When you need to capture the precise moment in Excel, the NOW function comes to your rescue. It retrieves the current date and time, presenting it as a serial number for your convenience. This functionality proves handy in various scenarios, especially when tracking data entry timestamps or creating dynamic reports that necessitate real-time information incorporation.
Examples
To display the current date and time in a cell, simply enter =NOW() in the desired cell. Excel will populate the cell with the serial number representing the current date and time. You can format the cell to show the date and time in your preferred layout.
You can use the NOW function to create a timestamp for when a specific action occurs in your Excel workbook. By incorporating the NOW function into formulas or conditional formatting rules, you can automate timestamp updates based on user actions or data changes.
You can use the NOW function to create a timestamp for when a specific action occurs in your Excel workbook. By incorporating the NOW function into formulas or conditional formatting rules, you can automate timestamp updates based on user actions or data changes.
Tips & notes
The NOW function recalculates whenever the worksheet is recalculated or when any value in the worksheet changes. Keep this in mind when using NOW for timestamping or real-time data analysis to ensure accurate results in your Excel workbooks.
Common questions
How does the NOW function handle time zones?
The NOW function retrieves the current date and time based on the system clock of the computer running Excel. It does not automatically adjust for different time zones, so the displayed date and time reflect the local time of the computer.
Can I customize the date and time format returned by the NOW function?
Yes, you can control the display format of the date and time returned by the NOW function using Excel's formatting options. By selecting the cell containing the NOW function output and applying a date or time format from Excel's formatting menu, you can adjust the appearance of the timestamp according to your preferences.
How frequently does the NOW function update?
The NOW function updates whenever the worksheet containing it recalculates. This recalculation may occur when any value in the worksheet changes or when forced by the user. If you need real-time updating of the current date and time, ensure that your worksheet is set to recalculate frequently or use manual recalculation to trigger updates.