Between Dates

  • Thread starter Thread starter exsam21
  • Start date Start date
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?
 
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
 
With:
Start Date in G1
End Date in H1

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

Does that help?

Regards,
Ron
 
Back
Top