Do you want to stamp a date on a spreadsheet? In Microsoft Excel, you have several ways to add today's date to your spreadsheets. You can add both static and dynamic dates, and we'll show you how.
See also: Microsoft Excel: How to clear formatting
When you add a static date to your Excel spreadsheet, the date doesn't update when you recalculate your worksheet or reopen the spreadsheet. It stays the same no matter what you do.
On the other hand, when you add a dynamic date to your spreadsheet, the date is updated when you recalculate your worksheet or when you reopen the spreadsheet. This date is added with an Excel function, so it is updated when you recalculate.
In any case, Excel retrieves the current date from computer , so make sure it is set to use the correct date.
In the spreadsheet, click the cell where you want to display today's date.
To enter today's date as a static value in your spreadsheet, first open your spreadsheet with Microsoft Excel.
See also: How to remove all images from a sheet in Microsoft Excel
With the cell selected, press Ctrl+; to add today's date to the cell. This keyboard shortcut works on both Windows and Mac.
Your cell now has today's date.
To add today's date in a way that updates when you recalculate or reopen your spreadsheet, use the Excel formula for today's date, TODAY.
To use it, open your spreadsheet with Microsoft Excel. Then, click the cell where you want the date to appear.
In the cell, type the following function and press Enter:
=TODAY()
And Excel will display today's date in your cell.
If you open your spreadsheet again, you will see that day's date.
If you prefer a specific format for your dates, Excel has the option to customize the date format. This way, you can display your date in any format you want.
See also: How to add numbers in Microsoft Excel
To do this for your date, right-click on the date cell and select "Format Cells" from the menu.
In the “Format Cells” window, from the “Type” section on the right, select the format you want for your date. Then click “OK” at the bottom.
Your date now uses the format you have chosen.
And this way you quickly display today's date in your various spreadsheets.
