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.
The first rule, in column A, formats future birthdays, and the rule in column C formats cells as soon as âYâ is entered, indicating that the birthday greeting has been sent. To create the first rule: Select cells A2 through A7. Do this by dragging from A2 to A7. Then, click Home Conditional Formatting New Rule.In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.Under Format values where this formula is true, type the formula: The formula uses the TODAY function to see if the dates in column A are greater than today (in the future). If so, the cells are formatted. Click Format.n the New Formatting Rule dialog box, click Use a formula to determine which cells to format. Under Format values where this formula is true, type the formula: The formula uses the TODAY function to see if the dates in column A are greater than today (in the future). If so, the cells are formatted. Click Format.