+3 votes
30 views
How to insert today's date in Microsoft Excel

in Guides by (487k points)
reopened | 30 views

1 Answer

+4 votes
Best answer

Insert today's date as static date in Excel
Add today's date as a dynamic date
Change date format in Excel

If you need to insert the date of today in Microsoft Excel , the program has several ways to get it . In this way we will be able to add static dates, but also dynamic ones. In the following article we are going to see a step-by-step guide of everything we must do to be able to add today's date to a Microsoft Excel spreadsheet..

Insert today's date as static date in Excel

image

To add a static date to our Microsoft Excel spreadsheet, we will have to click on the cell where we want to show today's date.

image

Next, we will have to press Ctrl +; (semicolon) to be able to add today's date. This is a keyboard shortcut that works the same way on Windows and Mac..

Add today's date as a dynamic date

Another option is to add today's date so that it is updated every time we open the spreadsheet. For that we are going to have to use the Excel formula "Today".

image

In order to use this function, we will have to open the spreadsheet and click on the cell where we want to show the date..

image

In the cell, we will have to write the following formula and press Enter: = TODAY ()

If we want to add the current date and time, we will have to use the formula = NOW ()

image

In this way, Excel will display today's date in the selected cell. If we reopen the spreadsheet on another day, it will show the updated date.

Change date format in Excel

If we want a specific format for the dates, Excel allows us to customize the format. In this way we will be able to show the date in the format we want.

image

To achieve this, we will have to right click on the cell that contains the date and choose “Format cells”.

image

Once we are in the "Cell Format" window, we will have to select "Type" on the right side. Here we have the option to choose the format we want for the date, then we click "OK" at the bottom.



by (3m points)
edited
How To Change Date Format - MS Excel

Related questions

+5 votes
1 answer
asked Dec 28, 2021 in Office by backtothefuture (487k points) | 17 views
+4 votes
1 answer
asked Feb 24 in Guides by backtothefuture (487k points) | 23 views
+4 votes
1 answer
asked Feb 24 in Guides by backtothefuture (487k points) | 23 views
+5 votes
1 answer
asked Jan 6 in Guides by backtothefuture (487k points) | 23 views
+4 votes
1 answer
asked Jan 3 in Guides by backtothefuture (487k points) | 20 views
Sponsored articles cost $40 per post. You can contact us via Feedback
9,351 questions
9,467 answers
483 comments
2 users