IF function based on dates in cell

ryn8985 

Let's say your Date column is Column A and the data begin in row 2. Let's also figure your table spans columns A thru Z.

In "Conditional Formatting" (Home ribbon), add a New Rule and choose "Use a formula to determine which cells to format". For the formula, use:

=TODAY()-$A2 > {insert # days}

And apply the rule to the entire table (A2:Znn, where nn = last row with data). Note the '$' MUST be in front of the column with the dates and there must be NO $ in front of the row number (2 in this example). Then set the formatting of the conditional format as you like (e.g., pick a "fill" color).