Search form. The Federal Trade Commission (FTC) is the nationâs consumer protection agency. The FTC works to prevent fraudulent, deceptive and unfair business practices in the marketplace. Share Our Resources. Here's How >.
If you want to input today's date in Excel that will always remain up to date, use one of the following Excel date functions: = 1 TODAY() - inserts the today date in a cell. = 2 NOW() - inserts the today date and current time in a cell.
=NOW(). This function returns both the current date and time. To change the display to show just the date, follow the steps for the =TODAY() function above. To change the display to show just the time: 1  Click on in the menus to bring up the Format Cells dialog box. 2  Click on the Number tab.TODAY(). This function returns the current date. To display the date in a different format than the default: 1  Click on in the menus to bring up the Format Cells dialog box. 2  Click on the Number tab. 3  Select Date in the Category window.