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 in 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 what the initial investment takes place.
Caution when using inserting today’s date in Excel
If you Insert the today’s date function in excel 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 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 becoming a financial analyst - networking, resume, interviews, financial modeling skills and more. We've seen 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 in Excel. CFI was founded with a simple purpose… to help anyone become a world-class financial analyst. With that goal in mind, these additional resources will help you become an Excel power user and an expert at financial analysis.
- Excel for dummiesExcel for BeginnersThis Excel for beginners guide teaches you everything you need to know about Excel spreadsheets and formulas to perform financial analysis. Watch the Video and learn everything a beginner needs to know from what is Excel, to why do we use, and what are the most important keyboard shortcuts, functions, and formulas
- 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.
- Index Match MatchIndex Match FormulaCombining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH 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
