Adding a New Condition to an IF Statement

[maic15]

I have the following IF Statement:
Formula in C2 is:
=IF(($A2>=DATEVALUE(LEFT($C2,FIND(" ",$C2)-1)))*($B2<=DATEVALUE(MID($C2,FIND("-",$C2)+2,LEN($C2)))),1,0)

I need to ad logic to reflect the new condtion below..Not sure how to do it..

Book1
	A	B	C	D	E
1	1	Start Date	End Date	Week
2	2	10/31/2005	11/4/2005	10/31/05 - 11/4/05	1
3	3	10/29/2005	11/4/2005	10/31/05 - 11/4/05	0
4	4	11/1/2005	11/4/2005	10/31/05 - 11/4/05	1
5
6	Add New Condition
7	5	10/31/2005	11/15/2005	10/31/05 - 11/4/05	1
8	6	10/21/2005	11/17/2005	10/31/05 - 11/4/05	1
Sheet1

 

[tactps]

You have not specified what how you want the new condition to be reflected. Are you looking to report on items between certain dates?

You could use and AND or OR formula:
=if(and(condtion1,condition2),true,false)

or perhaps another formula is better.

Tell us what your formula is supposed to do.

 

[maic15]

I need to add to the condtion if Start Date >= Week and End Date >= Week, then return 1. See condtion.

=IF(($A2>=DATEVALUE(LEFT($C2,FIND(" ",$C2)-1)))*($B2<=DATEVALUE(MID($C2,FIND("-",$C2)+2,LEN($C2)))),1,0)

 

[tactps]

Try:
=IF(AND(A2>=VALUE(LEFT(C2,SEARCH("-",C2)-1)),B2>=VALUE(RIGHT(C2,LEN(C2)-SEARCH("-",C2)-1))),1,0)

assumes consistent spacing between dates.

[EDIT]: I am not sure I would call 12 days "Week". Perhaps cells C1 should read "period"

 

[maic15]

One problem...If Start Date is greater than Left(Week) then return should be 0

SD = 11/5/05 and ED = 11/15/05, then 0