Hi - Im trying to compare dates using greater than () and less than (<)
operands in order to advance calculations. I am going to do a nested "IF"
statement (probably 3 or 4 levels) that will involve calculations. The
nested IF's will be comparing various dates (both dates in a cell, and "hard
coded dates"). I started with a simple 2-level nested IF returning only 0,
1, or 2, so I could confirm the logic worked before I put in the calcuating
formula's. They didn't work, and I noticed my "MM/DD/YY" date was not being
compared correctly in the cell. I think I got the first level IF to work but
the 2nd level failed - here's my current formula:
=IF(E3DATE(2005,2,14),(IF(D3<DATE(2005,6,6),0,1)) ,2) -- I was trying to use
the DATE function to make the conversion work - it seemed to work correctly
on the first IF but not the second. BOTTOM LINE - what is the correct way
to compare dates (one is greater than or less than the other) ? Thanks.