Excel 2007 TODAY Function

Add Today's Date to an Excel Spreadsheet

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.

1. Click on cell D1 - the location where the results will be displayed.
   
   
2. Click on the Formulas tab.
   
   
3. Choose Date & Time from the ribbon to open the function drop down list.
   
   
4. Click on TODAY in the list to bring up the function's dialog box.
   
   
5. Click OK.
   
   
6. Today's date should appear in cell D1.
   
   
7. When you click on cell D1 the complete function =TODAY( ) appears in the formula bar above the worksheet.

• Excel 2007 NOW Function
• Keyboard Shortcuts - Adding the Current Date in Excel
• Date Functions in Excel 2003