Get the Current Date in Excel

Add to Favorites

How to get the current date using Excel.  This method updates the date every day so that it is always accurate.

To do this we will use the TODAY() function.

Syntax

=TODAY()

There are no arguments for this function; you simply type it in as it is displayed above.

List the Current Date in Excel

Simply type =TODAY() into any cell where you want the current date to be displayed.

That's it!

You don't even have to change the formatting of the cell to a date because Excel will automatically do that for the TODAY() function.

If you want, you can change the format of the date that it displays by right-clicking the cell and going to Format Cells...

Then look to the Date formats on the Number tab and select whichever one you want and hit the OK button.

Notes

Every day that you open your spreadsheet, the date will update to that day's date.  You will never have to update another date in Excel again.

Dates will look different depending on your location.  The date above is displayed in the U.S. format where the month comes first.

This function may seem trivial but you can combine it with many other date and time functions in Excel in order to create more powerful spreadsheets.  Check out our Date and Time Tutorials for Excel.

If you want to also display the current time, look to our tutorial on the NOW function.

Make sure to download the accompanying workbook if you want to see this function being used.


Excel Function: TODAY()
Downloadable Files: Excel File

Similar Content on TeachExcel
NOW() - Display The Current Time in Excel
Tutorial: This Excel tip will show you how to display the current time within any Excel spreadsheet....
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Display the Current Day of the Week in Excel
Tutorial: Use a formula or formatting to display the current day of the week in Excel. Sections: For...
Print the Current Date or Time in Excel
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY
Tutorial: How to find a date that is so many days before or after a specified date, excluding weeken...
Quickly Enter the System Date in Excel - Keyboard Shortcut
Tutorial: You can insert the system Date by holding the Control (Ctrl) key and pressing the colon or...
Tutorial Details
Excel Function: TODAY()
Downloadable Files: Excel File
Similar Content
NOW() - Display The Current Time in Excel
Tutorial: This Excel tip will show you how to display the current time within any Excel spreadsheet....
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Display the Current Day of the Week in Excel
Tutorial: Use a formula or formatting to display the current day of the week in Excel. Sections: For...
Excel Forum