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.



Please enter your comment!
Please enter your name here

More From

Download and Install Third Party Apps on Samsung Smart TV

Your Samsung Smart TV comes pre-installed with cool apps for your entertainment. However, if you find 3rd party applications that you want to download...

How to Rotate or Make Text Vertical in Google Sheets

Google Sheets is an excellent tool for organizing data. There are times when you have a lot of data, and it becomes difficult to...

Fix No Device Detected Error in Corsair Utility Engine

If you are using Corsair devices, you may be using Corsair's Utility Engine or CUE. It is a software managing all the Corsair devices...

Activate Google Fi now on your iPhone using an eSIM

If you want to use Google Fi on your iOS device, you can easily activate it now on an iPhone through eSIM. Electronic SIM...

Recent Articles

Stay Connected