Urgent!!! Need Your Help!!!

  • Thread starter Thread starter dlopez34
  • Start date Start date
D

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
 
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
 
Back
Top