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 & Set up Apple Watch for a Family Member

There are a lot of functions that an Apple Watch can offer which is why many parents also want their kids to have one....

How to Clear or Delete Cache and Data on Hisense Smart TV

If you are looking for an affordable smart TV, you may have chosen Hisense smart TV. It is considered as one of the popular...

How to Find & Download your Video Watch History Data on TikTok App

TikTok has been a craze online with millions of people making TikTok videos, not to mention gaining popularity out of it. If you can...

How to Redeem Free 3 Months Disney Plus Subscription with a new Chromebook

Google is giving new Chromebook owners more reason to celebrate with its newest Disney Plus offer. Google announced on its website a deal that...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected