Date Range

[mrfredo82]

I need to indicate which dates fall within multiple date ranges.
Column A=Dates
Column H=Date Range Start
Column I=Date Range End
Column C=Value or Indicator

So if A1=7/9/2010
and H1=7/8/2010 (date range start)
and I1=7/10/2010 (date range end)
and H2=5/1/2005
and I2=5/10/2005
etc, etc

So I want C1 to return True or 1 if the date (A1) or False or 0 if the date does not match any of the date ranges in columns H and I.
This for all cells in column A (dates).

So C1=1 in this case.

Thank you!