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.
That will place the current time into the cell. To insert both the current date and the current time into the same cell, click on the cell where you want the date and time to be in your worksheet. Hold down the Ctrl key and press the; key.Now, hit the space bar and hold down the Ctrl and Shift keys and press the; key.o insert a dynamic date stamp into Excel, enter the following formula into any cell: =TODAY(). Excel will instantly put the current date into that cell. Every time you open the workbook or make a new calculation, Excel will update the cell to the current date.