YEAR and IF
 

I am trying a conditional statement to return "yes" if the date is in 2005.
I have used this

=IF(M2=YEAR(2005),"yes","") or =IF(M2=YEAR(AA2),"yes",""). The second
statement reference a cell w/ the year. I do not get any field to be "yes"
which I know is wrong.

Please advise.

Eventually I will want to use "OR" which will look for 2005 in multiple
columns. Thanks.

YEAR and IF
 

If M2 contains a date, I think you need something like this:

=IF(YEAR(M2)=2005,"yes","")

Hope this helps.

Pete

On Jan 9, 2:42*pm, PAL wrote:
I am trying a conditional statement to return "yes" if the date is in 2005.. *
I have used this

=IF(M2=YEAR(2005),"yes","") or =IF(M2=YEAR(AA2),"yes",""). *The second
statement reference a cell w/ the year. *I do not get any field to be "yes"
which I know is wrong.

Please advise.

Eventually I will want to use "OR" which will look for 2005 in multiple
columns. *Thanks.

YEAR and IF
 

Maybe

=IF(YEAR(A1)=2005,"Y","N")

Mike

"PAL" wrote:

I am trying a conditional statement to return "yes" if the date is in 2005.
I have used this

=IF(M2=YEAR(2005),"yes","") or =IF(M2=YEAR(AA2),"yes",""). The second
statement reference a cell w/ the year. I do not get any field to be "yes"
which I know is wrong.

Please advise.

Eventually I will want to use "OR" which will look for 2005 in multiple
columns. Thanks.