Referencing a date cell in a formula

[Kate]

Hi there!

I have a formula that is set up someting like this:

=IF(B4="6/1/2004",(K4),0)

The purpose of this formula is to return the result of K4
anytime B4=6/1/2004. ALSO, I'M NOT ABLE TO CHANGE THE
FORMAT OF B4 TO TEXT...

The result of the formula is always 0, because it's not
recognizing the date as the value that I'm looking for.
I've also tried with and without quotes...

Is there something I can put into the formula so that it
references B4, with the m/d/yyyy format it is in now?
Thank you,

Katie

 

[Bob Phillips]

Hi Kate,

Try this

=IF(B4=--("2004/06/01"),K4,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Charlie]

Katie,

Try

=IF(B4=DATE(2004,6,1),K4,0)

Charlie O'Neill

 

[Frank Kabel]

Hi Kate
try
=IF(B4=DATE(2004,6,1),K4,0)

 

[Frank Kabel]

Hi Bob
and my German version would return an error for this

 

[Bob Phillips]

I thought that we had ascertained earlier that this worked in all XL
international versions?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob
sorry, my fault. I made a mistake testing this!

 

[Bob Phillips]

Phew! You had me worried.

Bob

Hi Bob
sorry, my fault. I made a mistake testing this!