Answer for:

IF Statements

Message 6 of 5

View entire thread
1 Votes

Charles Bundy's answer is of course correct, and he answered the question you asked. However, remember that Excel's TODAY() function is a date stamp. I would have placed this formula in your "third" cell: =IF(I1<TODAY(), TRUE, FALSE). An advantage of doing this is evident if you then wish to copy down (or across) to apply the same formula to all of your contract expiry dates. Your original plan would have needed the date stamp reference to be an absolute reference: $H$3. Remember Charles' comment about HTML. My formula above has a "less than" character immediately before TODAY.