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
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.
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".
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..
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 ()
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.
To achieve this, we will have to right click on the cell that contains the date and choose “Format cells”.
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.