Step 4: The date should now be visible in your cell. Step 2: Click the cell in which the current date is to be displayed.

Step 1: Open the spreadsheet into which you want to add the current date. The Excel current date function might be preferable if you need the data in the cell to update to whatever the current date is. If you would prefer to have the date update as the day changes, then you can use the =TODAY() function instead of using the steps below. That value will remain in that cell, and will not update as the date changes. Note that the steps in this article will add the current date to your cell. Our tutorial below will show you how to use the keyboard shortcut, and also show how you can format the date to meet your needs.Įxcel Current Date Shortcut for Excel 2010 It can also be very easy to forget to change that information, which could have negative implications if the current date plays an important role in your data.įortunately there is a keyboard shortcut in Microsoft Excel 2010 that allows you to add the current date to a cell in your worksheet. If you are manually typing the current date into that cell, it can become tedious to do so over and over. If you have a spreadsheet that you update periodically in Microsoft Excel 2010, then you may also have a column where you keep track of the date when a record was added or modified. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.The Excel current date shortcut is one of the more useful, yet least-frequently-used options (at least in my experience) for many types of spreadsheets. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Be sure to set the formula calculation options to automatic Instant Connection to an Expert through our Excelchat Service: Tomorrow, the formula will automatically update to tomorrow’s date. We can see in this Example, the formula in B2 returns today’s date.

In cell B2, enter this formula =TODAY().

We can automatically generate the current date for each day by using the TODAY function By using the TODAY function, Excel users of all levels will be able to automatically reference the current date each day after reviewing this tutorialįinal Formula: TODAY() Applying the TODAY function

It is very simple to automatically generate a new date value each day. How to Get a Date to Automatically Update in Excel

How do i insert current date in excel