Hi Murray

Try either
IF(DATE(2006,3,27)<DATE(2006,10,13), value_if_true,value_if_false)
or
IF(--"27/03/06"<--"13/10/06", value_if_true,value_if_false)

--
Regards

Roger Govier


"Murray" wrote in message
...
Hi
I have a simple problems that is hopefully easy to answer.
is it possible to compare two dates eg =if(27/03/2006 <
13/10/2006,....)
if so can someone please advise.
Thanks