Discount % Between 2 Dates
 

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

Discount % Between 2 Dates
 

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

Discount % Between 2 Dates
 

Entered in B32:

=IF(AND(C41=DATE(2008,11,10),C41<=DATE(2009,1,2), E30=600),5%,0%)

Or:

=(C41=DATE(2008,11,10))*(C41<=DATE(2009,1,2))*(E3 0=600)*5%

--
Biff
Microsoft Excel MVP


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

Discount % Between 2 Dates
 

One way:

B32: = 5% * AND(C41=Date(2008,11,10), C41<=DATE(2009,1,2), E30=600)

Note: Your dates are ambiguous - I assumed MM/DD/YYYY rather than
DD/MM/YYYY


In article ,
joaniemic wrote:

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

Discount % Between 2 Dates
 

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

Discount % Between 2 Dates
 

DATE() uses the arguments Year, Month, Day so it should not matter what date
system you have set. What would have helped was if I had the month and day
the right way round in the second date try:


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

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

Discount % Between 2 Dates
 

Oops! I see what you mean I got so carried away with the 5% I forgot about
the =600 part. Make that:

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

--
HTH

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


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


"Sandy Mann" wrote in message
...
DATE() uses the arguments Year, Month, Day so it should not matter what
date system you have set. What would have helped was if I had the month
and day the right way round in the second date try:


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

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