Question
May 15, 2012 at 04:29 AM
leonard0509

IF Statements

by leonard0509 . Updated 14 years, 3 months ago

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(H3I1, FALSE)) but this doesn’t seem to work.

Note: Cell I1 is the date stamp, Cell H3 is the contract expiry Date.

This discussion is locked

All Comments