Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
The NOW Function in Excel is a formula that displays the current date and time. It is automatically refreshed anytime the workbook is opened or a change is made. It can also be manually refreshed by pressing F9. To learn more, launch our free Excel crash course now!
Formula for the NOW function in Excel
Below is the formula for the NOW function in Excel:
Please note, you must include the parentheses and do not type anything between them.
Example of the NOW function in Excel
Here is a screenshot of the NOW function in Excel at the current time and date.
As you see in the example above, the formula is simply equal to =NOW() and the date, as well as the time, are automatically displayed in the cell.
The TODAY function is similar in that it displays the current date, but it doesn’t include the time.
Why use the NOW function in Excel?
This function can be very useful for spreadsheets that require printing, and where a time stamp on that printout would be helpful.
Another reason would be to clock in and clock out. If you set up a table, you can copy and paste as values the time when you start and then copy and paste as values the time when you stop. This way, you can easily keep track of the exact time.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.