HomeHow ToHow to Insert Current Date in a Cell Using Today Function in...

How to Insert Current Date in a Cell Using Today Function in Microsoft Excel



Adding the current date on your Microsoft Excel worksheet will allow you to identify various data and sheets. While we make use of static dates on most of our spreadsheets, did you know that you can also add a dynamic date?

A static date is when you manually type the current date on a cell, and it does not change until you manually change it. If you wish the date to update every day, you can add a dynamic date using the Today function.

Photo credit: rawpixel/Freepik

The MS Excel Today function will automatically get and set the current date as the value on the cell whenever you reopen the sheet or recalculate it. You do not need to change it each day. The tool changes and updates on its own.

How to Get & Insert Current Date & Time in an MS Excel Cell Using the Today Function

The Today function has a syntax TODAY(), wherein TODAY is in capital letters followed by an open and close parenthesis. To insert the current date into your Microsoft Excel spreadsheet, click the cell where you want to add the current date. Enter the following formula: =TODAY(). It will automatically show the current date in the following format: month, day, and year.

Note that the cell containing the Today function will automatically change each day based on the current date. You can change the formatting of the current date by selecting the cell where you added the Today function and right-click on it. Select Format Cells. Navigate to the Number tab and click Date. You can choose the format under the Type section.

Using the Today Function in Microsoft Excel Sheets

The Today function is useful in other formulas and not just to insert the current date on your Microsoft Excel sheet. If you need to create formulas that automatically change based on the current date, you can add the Today function.

For instance, if you need to know what the exact date after 27 days from the current date, you can apply the Today function in your formula such as, =TODAY()+27. It means that the Today function represents the current date adding 27 days after it to obtain the exact date you need.

You can also use the Today function if you only want to show the current day devoid of the month and year. For example, if the current date is June 1st, 2022, you can create a formula such as =DAY(TODAY()), if you only want to show 1 and not June and 2022.

Many other applications are using the Today function. It is ideal for financial reports where the current date is crucial and affects other data in the worksheet.

How do you like using the Today function so far? Is it helpful for you? We love to know where you apply the Today function. You can tell us more in the comment section below.


More From

How to Use Nicknames in Discord Servers

Being in Discord gives you platform for various conversations and connections online. Whether you are a gamer or wanting to share your love...

How to Fix Netflix Error NW-4-7, NW-4-8 and NW-2-5

If you encountered any of these Netflix errors: NW-4-7, NW-4-8 and NW-2-5, then this article can help you find the right solution to solve...

How to Export & Transfer your LastPass Passwords to 1Password

Passwords are our means to secure our online accounts. Unfortunately, our passwords are still not 100% safe from hackers. That is why password managers...

How to Get Apple Music App on Samsung Smart TVs

Samsung Smart TV users can now enjoy Apple Music content thanks to the recent collaboration by the two tech giants. Another partnership between Apple...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected