Reference Date with Or Function

R

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
 
N

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
 
T

Teethless mama

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