Insert the current date and time into an Excel spreadsheet
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.
For anyone working as a financial analyst, it can be useful to insert the current time and date into an Excel spreadsheet. This guide will break down how the Excel current date and time function works and outline situations where it will be helpful in your analysis.
Excel current date and time formulas (dynamic)
There are two formulas to use, depending on what type of information you’re looking to insert in your spreadsheet. Note: These are dynamic formulas and will update whenever a spreadsheet is opened.
Current date formula:
Current time formula:
Excel current date and time example
Let’s look at a real example in an Excel spreadsheet of how these two formulas work. In the screenshot below, you can clearly see how each works and what the corresponding output is. For example, if, at the time of creating the formula, it’s May 24, 2018 at 1:36 p.m., then the following information will appear in your spreadsheet. NOTE: Excel uses a 24-hour clock when it outputs the time.
As you can see, the =TODAY() formula only includes the day, month and year. The =NOW() function displays more information, showing the day, month, year, hour and minutes (using a 24-hour clock).
Excel current date and time formulas (static)
You may not always want the figures in the file to update every time you open the file. If this is the case, then you’ll want to insert a static version of the formulas.
Static formulas are:
“Ctrl + ;” – inserts the date (Windows)
“Ctrl + Shift + ;” – inserts the date and time (Windows)
“COMMAND + ;” (Mac)
Why insert current date and time in Excel?
There are many reasons you may want to display the current date and time in Excel. Let’s say that you want users to have the current time displayed on a cover page every time you print off a financial model.
You may wish to change the format of date or time displayed in the spreadsheet. In order to do this, press F1 (or right-click on the cell and click Format Cells). Once you see the Format Cells box appear on the screen, you can click on Number and then select Date or Time and choose the formatting you want to appear in your spreadsheet.
Applications in financial modeling
The Excel current time and date function is very useful in performing financial analysis, as time is a critical factor in financial modeling and valuation. The most important use is in discounting cash flows and ensuring that the net present value date is correct. You may wish to use a static or dynamic version of the formulas shown in this article, depending on the analysis being performed.
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.