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.
Step 2. (Image: Screenshot courtesy of Microsoft.). Press Enter to have Excel calculate the formula. The calculated value, today's date, is visible in the cell. Double-click the cell to see the formula, or single-click the cell to view the formula in the Formula field above the worksheet.lick the cell in which you want a future date to appear. Type = and then click the cell containing the current date. Type + and then the number of days you want in the future, such as = B2+10.