Perhaps this is easier to understand rather than that obfuscated formula.

=IF(AND(C1=A1,C1<=B1),1,0)

Tyro

"Laura Logan" wrote in message
...
I am trying to create a function in a spreadsheet but not sure how to go
about it. I have a start date in A1 and and end date in B1. If column c1
falls between those dates, I want to have the cell in D1 enter the value
of
1. If c2 does not fall between those dates, then I want it to enter the
value of 0. Can this be done?
--
Laura