How to display the current date in a cell in Microsoft Excel

Microsoft Excel

In general, when talking about spreadsheets and the Microsoft Excel program, we tend to think mainly about numbers and mathematical operations. However, the truth is that you can also perform calculations with dates, currencies and many more types of numbering, something that can come in quite handy in some cases.

Within these types of requirements, one of the most useful functions is the one that it is responsible for displaying the current date, since it can be interacted in many ways with the result of said operation. However, it may not have been so easy for you to find the function in question to use that allows you to display this information.

Use the function TODAY to display the current date in Microsoft Excel

As we mentioned, although it is true that showing the current date can be quite useful in some cases, so as to be able to later carry out conditional actions in other cells on the result, you may not know how the current date can be displayed.

However, you should not worry about it, as function exists TODAY, which as Microsoft describes "Returns the current date with date format." In this way, in order for the current date to be displayed in a certain cell, all you have to do is hover over the formula input box, and then type =HOY().

TODAY function in Microsoft Excel

Function TODAY in Microsoft Excel

Microsoft Excel
Related article:
Activate autosave in Microsoft Excel and don't lose the changes in your spreadsheets

By doing this and saving the change, you will see how the cell format becomes the date format, and the current date is entered in it depending on the configuration of your computer, in the same regional format as it. It should also be noted that this function in question does not support other additional values currently, which is why you will not be able to enter any value or variable between the parentheses. It only serves to show the current data.


The content of the article adheres to our principles of editorial ethics. To report an error click here!.

Be the first to comment

Leave a Comment

Your email address will not be published.

*

*

  1. Responsible for the data: Miguel Ángel Gatón
  2. Purpose of the data: Control SPAM, comment management.
  3. Legitimation: Your consent
  4. Communication of the data: The data will not be communicated to third parties except by legal obligation.
  5. Data storage: Database hosted by Occentus Networks (EU)
  6. Rights: At any time you can limit, recover and delete your information.