Urgent!!! Need Your Help!!!

[dlopez34]

IS THERE A FORMULA THAT WILL LET ME SEARCH IN A RANGE DATE FOR A VALU
FOR EXAMPLE

IF 3/22/2004
IS BETWEEN SAY 03/21/2004 AND 03/27/2004
AND IF TRUE IT SHOULD EQUAL ANOTHER CELL... LIKE SAY ONE THAT IS FO
$35.60, IF NOT THEN JUST A 0 WOULD DO.

I HAVE COME UP WITH THIS LOGIC

B4=03/22/2004
C4 = $35.60

IF B4 IS BETWEEN 03/21/2004 AND 03/27/2004
THEN B4=C4
ELSE B4 = 0

THANK YOU VERY MUCH....................DIAN

 

[Juan Sanchez]

The logic works out great just put it in a formula:

=IF(AND(B4>DATEVALUE("21/03/2004"),B4<DATEVALUE
("27/03/2004")),C4,0)

YOU MIGHT HAVE TO CHANGE THE ORDER OF "DD/MM/YYYY" SINCE
I'M IN MEXICO...

Cheers
Juan