I’m trying to figure out an IF statement that will show me if a contract has expired.
Example. Expiry date of contract 28/09/2011, I’ve got a date stamp of 15/05/2012
I need an IF statement which will turn a cell to true if the contract expiry date is less than the date stamp, the current formula i have is
=IF(H3
Note: Cell I1 is the date stamp, Cell H3 is the contract expiry Date.