In this article, you will learn how to use the NOW formula in Excel.
The NOW function in Excel returns the serial number of the current date and time. The function has no arguments, and the result is updated each time the spreadsheet is recalculated or opened.
The NOW formula in Excel is beneficial in several ways. Some of the most common uses include the following cases.
The NOW formula can be used in Excel by simply typing as follows:
This will automatically insert the serial number of the current date and time into the cell.
Note 1: If the format of the cell, which includes the NOW function, is general, Excel automatically changes the style of the cell to the one for your regional default setting.
Note 2: In a serial number, numbers to the right of the decimal point represent the time element.
For example, if you want to track when a task is completed, you can insert the NOW formula in the cell next to the task description, and it will automatically update the time when the job is over.
As another example, the NOW formula can be used as an argument in date-related formulas, such as EDATE and EOMONTH. For instance, the formula below shows the date two months later.
Note that the time element is removed from the outcome of other functions to show a specific “date” without time.
Additionally, you can format the results of the NOW function to display the date and time in a specific way. For example, you can use the "TEXT" function to format the date and time to show only the time, or only the date, or in a specific format.
The formula above will return the current date and time in the format of Month/Day/Year Hour:Minute:Second. You can also use the different built-in date and time formatting options in excel to format the result according to your needs.
The following screenshot shows examples of the NOW function combined with other formulas.
Yes, the NOW function in Excel updates automatically each time the spreadsheet is recalculated or opened. It is important to remember that the NOW function only updates when the spreadsheet is recalculated or opened. Thus, if you want the function to reflect the current date and time at all times, you should make sure to recalculate the spreadsheet periodically or open it regularly. In case you want to stop the cell from updating automatically, you can copy the result of the formula and paste it as a value (without formatting or formula), as explained above. This will retain the current value in that cell, and it will not change even if you open the sheet after some time.
The NOW function in Excel returns the current date and time, and you can use it to display today's date by formatting the result to only show the date portion.
Here's an example of how you can use the NOW function to display today's date in a cell:
Alternatively, you can also use the =TODAY() function, which returns the current date.
The TODAY and NOW formulas in Excel are common in that they are automatically updated when the Excel file is refreshed or reopened. However, they are slightly different in terms of their functionality. The NOW function returns the current date and time as a serial number, which can be formatted to display the date and time differently. On the other hand, the TODAY function returns only the current date as a serial number. It does not include the time. So, in summary, you can use the NOW function when you want to know the current time and insert the TODAY formula (or the NOW function if you prefer) when you need to know the current date.
Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇