Between Dates

E

exsam21

cell b2=02/11/2006
cell c2=100
cell d2=200

I want my result to be if b2 is between a certain date range, then add
c2 and d2, else 0. How do I perform the date range part of the
formula?
 
C

ChelseaWarren

Try this formuila:

=IF(AND(B2<=DATE(2006,3,1),B2>=DATE(2006,2,1)),C2+D2,0)

this will check whether your date is between the range 2/1/06 and 3/1/06
 
R

Ron Coderre

With:
Start Date in G1
End Date in H1

E2: =(B2>=$G$1)*(B2<=$H$1)*SUM(C2:D2)

Does that help?

Regards,
Ron
 
Top