How to use Excel today’s date function
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:
=today()
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 modelingWhat is Financial ModelingFinancial modeling is performed in Excel to forecast a company's financial performance. Overview of what is financial modeling, how & why to build a model. A 3 statement model links income statement, balance sheet, and cash flow statement. More advanced types of financial models are built for valuation, plannnig, and, adding today’s date is very useful for discounting cash flowsDCF Analysis InfographicHow discounted cash flow (DCF) really work. This DCF analysis infographic walks through the various steps involved in building a DCF model in Excel. 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.
This is especially important for a financial analystGuide to Becoming a Financial AnalystHow to become a financial analyst. Follow CFI's guide on networking, resume, interviews, financial modeling skills and more. We've helped thousands of people become financial analysts over the years and know precisely what it takes. performing their work in Excel.
More Excel resources
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.
- Excel for dummiesStudyOur articles and guides will help you self-study Excel to learn all the most important formulas, functions, shortcuts and more for spreadsheets
- Excel shortcutsExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts
- Excel formulas listExcel Formulas Cheat SheetCFI's Excel formulas cheat sheet will give you all the most important formulas to perform financial analysis and modeling in Excel spreadsheets. If you want to become a master of Excel financial analysis and an expert on building financial models then you've come to the right place.
- Index Match MatchIndex Match FormulaCombining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH in this Excel tutorial. Index returns the value of a cell in a table based on the column and row number and Match returns the position of a cell in a row or column. Learn how to them in this guide
- Find and replaceFind and Replace in ExcelLearn how to search in Excel - this step by step tutorial will teach how to Find and Replace in Excel spreadsheets using Ctrl + F shortcut. Excel find and replace allows you to quickly search all cells and formulas in a spreadsheet for all instances that match your search criteria. This guide will cover how to
