I would like to create columns to display an "X" if a date falls within a
range of a check-in and check-out date. This is the fomula I have tried, and
failed.

=(if($c$1=A2),if($c$1b2),"X","")
A B C
D E
Check In Date Check Out Date 1/26/2007 1/27/2007 1/28/2007
1/28/2007 2/2/2007 X
1/28/2007 2/2/2007 X
1/28/2007 1/31/2007 X
1/28/2007 2/2/2007 X

I want a null value if it doesn't fit the criteria. Can you please tell me
what I am doing wrong?

Thank you in advance for your help

=IF(AND(C1=A2,C1B2),"X",""))

Dave
--
Brevity is the soul of wit.


"Susie" wrote:

I would like to create columns to display an "X" if a date falls within a
range of a check-in and check-out date. This is the fomula I have tried, and
failed.

=(if($c$1=A2),if($c$1b2),"X","")
A B C
D E
Check In Date Check Out Date 1/26/2007 1/27/2007 1/28/2007
1/28/2007 2/2/2007 X
1/28/2007 2/2/2007 X
1/28/2007 1/31/2007 X
1/28/2007 2/2/2007 X

I want a null value if it doesn't fit the criteria. Can you please tell me
what I am doing wrong?

Thank you in advance for your help