IF formula misbehaving with determining year of an event
 

In D14 I enter 04/23/2008
in D15 the formula contains
=IF(RIGHT(D14,2)="08","true_value","false_value")

Why is D15 returning "false_value"?
I'd expect "true_value"

Thanks for your help.
Pierre

IF formula misbehaving with determining year of an event
 

Because you are trying to use the RIGHT function (which is designed to
manipulate a string) with a value; in Excel 4/23/08 is equal to 39561
because it is counting the number of days since 1/1/1900.

Try using YEAR instead of RIGHT:
=IF(YEAR(D14)=2008,true,false)


On Apr 24, 10:01 am, Pierre wrote:
In D14 I enter 04/23/2008
in D15 the formula contains
=IF(RIGHT(D14,2)="08","true_value","false_value")

Why is D15 returning "false_value"?
I'd expect "true_value"

Thanks for your help.
Pierre

IF formula misbehaving with determining year of an event
 

Reitanos,
Thank you for clarifying. Works fine now.

Pierre

On Apr 24, 9:12*am, Reitanos wrote:
Because you are trying to use the RIGHT function (which is designed to
manipulate a string) with a value; in Excel 4/23/08 is equal to 39561
because it is counting the number of days since 1/1/1900.

Try using YEAR instead of RIGHT:
=IF(YEAR(D14)=2008,true,false)

On Apr 24, 10:01 am, Pierre wrote:



In D14 I enter 04/23/2008
in D15 the formula contains
=IF(RIGHT(D14,2)="08","true_value","false_value")

Why is D15 returning "false_value"?
I'd expect "true_value"

Thanks for your help.
Pierre- Hide quoted text -

- Show quoted text -

IF formula misbehaving with determining year of an event
 

You could try:
=IF(TEXT(A5,"yy")="08","true_value","false_value")

HTH,
Paul




--

"Pierre" wrote in message
...
In D14 I enter 04/23/2008
in D15 the formula contains
=IF(RIGHT(D14,2)="08","true_value","false_value")

Why is D15 returning "false_value"?
I'd expect "true_value"

Thanks for your help.
Pierre