Reference Date with Or Function

[rac]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[rac]

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


Gord Dibben MS Excel MVP

Thanks Much! It seems so simple now.

rac

 

[Guest]

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