Formula that returns 1 if dates falls in date Range

[simplyc]

Hello All,
I am in need of a formula that returns "1" if the start date is before or on the active date and if the close date is before or equal to the active date. I am trying to determine how many project are active in that month. If the project is not active, I would like a 0 returned.
Here is an example of what the spreadsheet would look like:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Column BM
Start Date[/TD]
[TD]Column BN
Close Date[/TD]
[TD]Column BP
Active
1/15/2015[/TD]
[TD]Column BQ
Active
2/15/2015[/TD]
[TD]Column BR
Active
3/15/2015

[/TD]
[/TR]
[TR]
[TD]1/26/2015[/TD]
[TD]3/1/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/2/2013[/TD]
[TD]8/15/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/2/2013[/TD]
[TD]8/15/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I tried the formula below and it did not work:
[TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl63, width: 71"]=IF(OR(BM6<=BP4,BO6<=BP4),"1","0")[/TD]
[/TR]
</tbody>[/TABLE]

Any Help would be greatly appreciated !

 

[simplyc]

I apologize it returned TRUE when I tested my date for BP

Any ideas as to why my formulas are not working ? The dates are all in Date formatting.

 

[simplyc]

Whichever cell in Column BP has your date in it, perform the same test using that cell's address.

Any ideas as to how I should change my formula Rick?

 

[Rick Rothstein]

Any ideas as to how I should change my formula Rick?

Actually, I am at a loss... all your dates seem to be real dates... given that, the formula that I and bbot posted should have worked. I am not sure what the problem could be. If you would like to send me a copy of the workbook in question, I would be happy to take a look at it and see if I can spot the problem. My email address is...

rick DOT news AT verizon DOT net

Please mention this thread's title in your email so I can find this thread again more easily.