A formula the dynamically displays the current date in a 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.
In Excel, today’s date can easily be inserted using the =today() formula. This little-known function allows you to insert today’s date easily into any cell in the spreadsheet. The function is very straightforward and easy to use, as follows:
To insert today’s date in Excel you simply type “=today” in the cell and then open and close brackets “()” with nothing in between them.
Why use the Excel today’s date function?
For financial modeling, adding today’s date is very useful for discounting cash flows and calculating the net present value (NPV) of an investment. The today function can also be used to create a dynamic model that calculates the number of days elapsed since a certain previous date.
Because timing can make a big difference in the value of cash flows, it’s important to be very precise about when an initial investment takes place.
Caution when using inserting today’s date in Excel
If you insert the Excel today’s date function, then you will be creating a dynamic formula that will update every time you open up the spreadsheet.
In some cases, you may want to hardcode the date so that it’s fixed and won’t update every time you open Excel. This will allow you to preserve your analysis without the impact of date/times changes.
Thank you for reading the CFI guide to inserting today’s date. CFI was founded with a simple purpose – to help anyone become a world-class financial analyst. With that goal in mind, these additional CFI resources will help you become an Excel power user and an expert at financial analysis.
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.