Check a date to find if it falls between a range of dates

Hello again, friends.
I am looking for a simple formula that checks a range of dates (Start dates in Column A and end dates in Columns B) and matches it against a specified date (eg, C1).
If the date on C1 matches to a date between the range in columns A and B, then return in D1 a one; otherwise return a zero.
Struggling with this...

Hi,

Try below formula:

=IF(SUMPRODUCT((C1>=$A$1:$A$6)*(C1<=$B$1:$B$6)),1,0)

You are a star, as always.

Thanks for the feedback. Please mark the thread as SOLVED and click the star of ADD REPUTATION if you feel the solution helped you.