I have my date formatted as 11/10/08 (for November 10, 2008). Would your
formula change since this is the case? It doesn't seem to be working. Thanks!

"Sandy Mann" wrote:

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%.