Insert Todays Date in Excel

A formula the dynamically displays the current date in a spreadsheet.

How to insert today’s date in Excel

Excel has a very useful and little known function that allows you to insert today’s date.  The function is very straightforward and easy to use, as follows:

=today()

To insert todays date in excel you simply type “=today” in the cell and then open and close brackets “()” with nothing in between them.

Why use the todays date function in Excel?

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 amount 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.

A word of caution when using the today function

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 analyst performing their work in Excel.

More learning in Excel

Excel for dummies
Excel shortcuts
Excel formulas list
Index Match Match
Find and replace