Try:

=E30-(5%*E30*(C41=DATE(2008,11,10))*(C41<=DATE(2009,2, 1)))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"joaniemic" wrote in message
...
I am trying to have a 5% discount appear if an order is placed between (and
including) two dates...
If C41 is between (and including) 11/10/2008 and 01/02/2009 and E30 is
equal
to or greater than $600, B32 is 5%, otherwise B32 is at 0%.