NOW Function

Category: Date and Time

Compatibility: Excel 2019, Excel 2019 for Mac, Excel 2021, Excel 2021 for Mac, Excel 365, Excel 365 for Mac, Google Sheets


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.

Official documentation of the NOW Function