return TRUE if a date falls between two dates
=IF(SUMPRODUCT(--(StartD<=A5),--(EndD=A5)),"T","F")
I wasn't entirely clear from Christine's posting which conditionals should
be considered True and which False; but assuming she liked the results your
formula yielded, I think this formula will work also....
=MID("FT",1+(StartD<=A5)*(EndD=A5),1)
Rick
|