IF(date = 2007)

[Ctech]

Hi,

I need to make a formula which can take a date formatted cell 01/01/2007, and take only the 2007 and compare that to a cell with general format with the txt 2007.

If I use =RIGHT(A1;4) i get the date serial rather than the year... how can I pull out only the 4 digit year..?

[zbor]

Take CUSTOM format for a cell and put yyyy

Like this: 1.JPG

You don't need to cut date.. He'll take only year from whole date

[Ctech]

I know this.. it is my fault.. I'm explaining my issue poorly

Let say I have two cells

A1 = 2007
A2 = 01/01/07 but custom format yyyy = displayed as 2007

However what if I want to use VLOOKUP(A2;A1;0;FALSE)

Now VLOOKUP will not recognise that A1 is the same as A2.

I therefore need to implement function x in my formula so that either A1 or A2 is formatted to the same format. So they are seen as the same value in Excel .

I hope this makes it clearer.

[zbor]

Oh, I see... Then put YEAR(A32) in lookup value.. but in table array must be 2007

=VLOOKUP(YEAR(A2);A1;0;FALSE) where A1 must be 2007, and A2 can be date