Nested If Function
Column A has dates.
Cell H3 is a start date. Cell I3 is an end date.
I want to display Y in Column J if the date in Column A lies between the two
dates in H3-I3.
I'm using this formula, but get a Y even when the date in Column A is
outside the date range.
=IF(AND(A7=H3,A7<=I3),"Y","N")
H3 = 09-01-06
I3 = 09-04-06
Still displays Y when date is 9-5-06 or above.
Need help!
|