Hello,

How can I make my IF statement say "=IF(C4=B2+30,1,2)" and C4 is a fixed
date and B2 is the system date (=TODAY() ). I want to add a statement that
says if the fixed date is greater than or equal to system date, return a 1,
if not return a 2. So later I can go and count all the 1's and then count all
the 2's, but I can't get the statement to work. The first one was 4/2/2009
and it is returning a 2 and it should be a 1.

Thanks for whatever help anyone can give.

Valerie