If cell is minus one of multiple numbers

[Scrambo]

Basically, I have a cell that equals a date(A1) and another cell that is an earlier date(B1). I need to get "If(or(b1=a1-1, b1=a1-2,b1=a1-3,...b1=a1-84),Z,Y)". Is there a shorter way to achieve this?

 

[Joe4]

Maybe something like:

=IF(AND(B1<=(A1-1),B1>=(A1-84)),Z,Y)

 

[etaf]

answered<a1)< html=""></a1)<>

 

[Scrambo]

Works perfect! Thanks so much

 

[Joe4]

You are welcome.

 

[Scott Huish]

You could also use MEDIAN to see if it is between 2 numbers:

=IF(MEDIAN(B1,A1-1,A1-84),"Z","Y")