Between Dates
Hi Tom
=IF(AND(C2=A2,C2<=B2),1,"")
--
Regards
Roger Govier
"lehigh46" wrote in message
...
Hi All,
I have dates in A2, B2 & C2.
I need a formula in D2 which yeilds a number one if C2 falls between
A2 & B2
Can anyone help me.
Thanks very much
Tom Snyder
|