Between Dates

[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?

[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

[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



"exsam21" wrote:

>
> 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?
>
>
> --
> exsam21
> ------------------------------------------------------------------------
> exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666
> View this thread: http://www.excelforum.com/showthread...hreadid=521172
>
>