The TODAY function, one of Excel's date and time functions, is used to add today's date to a spreadsheet.
The syntax for the TODAY function is:
=TODAY( )
Note: The TODAY function takes no arguments.
Example Using Excel's TODAY Function:
Note: For help with this example, see the image to the right.
- Click on cell D1 - the location where the results will be displayed.
- Click on the Formulas tab.
- Choose Date & Time from the ribbon to open the function drop down list.
- Click on TODAY in the list to bring up the function's dialog box.
- Click OK.
- Today's date should appear in cell D1.
- When you click on cell D1 the complete function =TODAY( ) appears in the formula bar above the worksheet.
Related Articles


