Between Dates
 

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

Between Dates
 

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

Between Dates
 

With:
Start Date in G1
End Date in H1

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=521172