Reference Date with Or Function
 

I'm trying to use an Or() function to reference a cell which is formated
as a date. I get an error every time I try.

If(OR(A2={B2,B6}),"text","")

A2, B2 and B6 are all dates.


rac

Reference Date with Or Function
 

=IF(OR(A2=B2,A2=B6)),"text","")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"rac" wrote in message ...
| I'm trying to use an Or() function to reference a cell which is formated
| as a date. I get an error every time I try.
|
| If(OR(A2={B2,B6}),"text","")
|
| A2, B2 and B6 are all dates.
|
|
| rac

Reference Date with Or Function
 

=IF(OR(A2=B2,(A2=B6)),"text","")


Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 16:33:00 -0500, rac wrote:

I'm trying to use an Or() function to reference a cell which is formated
as a date. I get an error every time I try.

If(OR(A2={B2,B6}),"text","")

A2, B2 and B6 are all dates.


rac

Reference Date with Or Function
 

Gord Dibben wrote:
=IF(OR(A2=B2,(A2=B6)),"text","")


Gord Dibben MS Excel MVP

On Thu, 16 Nov 2006 16:33:00 -0500, rac wrote:

I'm trying to use an Or() function to reference a cell which is formated
as a date. I get an error every time I try.

If(OR(A2={B2,B6}),"text","")

A2, B2 and B6 are all dates.


rac



Thanks Much! It seems so simple now.

rac

Reference Date with Or Function
 

You have a correct formula. All you have to commit ctrl+shift+enter (not just
enter)


"rac" wrote:

I'm trying to use an Or() function to reference a cell which is formated
as a date. I get an error every time I try.

If(OR(A2={B2,B6}),"text","")

A2, B2 and B6 are all dates.


rac