Microsoft Excel logo on a green background

Need to stamp a date on a spreadsheet? In Microsoft Excel, you have multiple ways to add today’s date in your spreadsheets. You can add both static and dynamic dates, and we’ll show you how.

Static vs Dynamic Dates in Excel

When you add a static date in your Excel spreadsheet, the date does not update when you recalculate your worksheet or you reopen the spreadsheet. It remains the same no matter what you do.

On the other hand, when you add a dynamic date to your spreadsheet, the date updates when you recalculate your worksheet or you reopen the spreadsheet. This date is added with an Excel function, which is why it’s updated when you perform recalculation.

In either case, Excel fetches the current date from your computer’s system clock, so make sure it’s set to use the correct date.

RELATED: How to See Multiple Time Zone Clocks on Windows 10's Taskbar

Insert Today’s Date as a Static Date in Excel

To insert today’s date as a static value in your spreadsheet, first, open your spreadsheet with Microsoft Excel.

Advertisement

In the spreadsheet, click the cell in which you want to display today’s date.

Select a cell to display the date in an Excel spreadsheet.

While the cell is selected, press Ctrl+; (semicolon) to add today’s date in the cell. This keyboard shortcut works on both Windows and Mac.

Your cell now has today’s date in it.

Tip: To add the current time, press Ctrl+Shift+; on Windows or Command+; on Mac.

Today's date in a cell in Excel.

That’s it.

Add Today’s Date as a Dynamic Date in Excel

To add today’s date in such a way that it 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 in which you want to display the date.

Select a cell to display the date in an Excel spreadsheet.

In the cell, type the following function and press Enter:

=TODAY()
Tip: To add both the current date and time, use the =NOW() formula instead.

Enter the function to add today's date.

And Excel will display today’s date in your cell.

Today's date added with a function in Excel.

If you reopen your spreadsheet, you will see the date of that day.

RELATED: How to Manually Calculate Only the Active Worksheet in Excel

Change the Date Format in Excel

If you prefer a specific format for your dates, Excel has an option to customize the date format. This way, you can display your date in whatever format you desire.

Advertisement

To do that for your date, right-click your date cell and select “Format Cells” from the menu.

Right-click the date cell and choose "Format Cells."

On 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.

Select a date format and click "OK" on the "Format Cells" window.

Your date now uses your selected format.

Today's date in a different format.

And that’s how you quickly display today’s date in your various spreadsheets. Very useful!


Excel has various features with regards to dates, like the ability to sort your data by date or calculate age in your spreadsheets.

RELATED: How to Sort by Date in Microsoft Excel

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.