The NOW function in Excel is used to return the current date and time. Every time the worksheet is recalculated or opened, the NOW function updates to display the current date and time.
Syntax of the NOW Function
The function does not have any arguments, making it simple to use. You can enter it into a cell with the formula:
Output of the NOW Function
The returned value is formatted as a date and time, but you can change the formatting to display only the date or only the time if needed.
NOW Function Use Cases
This function is particularly useful for timestamping and for calculations that require the current date or time.