=IF (AND(A1=B1,A1<=C1),"between","not between")
=A1=MEDIAN(A1:C1)

If the date/number in C1 is always greater than or equal to the date/number
in B1 those formulas are checking for the *exact same thing*. The only
difference is the MEDIAN formula returns either TRUE or FALSE

Try it like this and you'll get identical results from both formulas.

=IF(A1=MEDIAN(A1:C1),"between","not between")
=IF(AND(A1=B1,A1<=C1),"between","not between")



--
Biff
Microsoft Excel MVP


wrote in message
...
On Mar 27, 5:20 pm, "T. Valko" wrote:
Another one:

=A1=MEDIAN(A1:C1)

Actually I don't think this would work, because I am not always
looking for the MEDIAN of the two dates (plus your formula as written
is self-referential). Lars-Åke's suggestion is exactly what I needed,
but thanks anyway!

Kent