Date Reformating Question

[Ksean]

This is actually a two part question.

First: I have more than 650 birth dates arranged on a spreadsheet with the
birth months in column ‘G’, the birth day in column ’H’ and the birth year
in column ‘I’, is there a way to combine the three columns into one column
eliminating the three separate columns?

Second: I use this formula =VLOOKUP(I3,Start!$B$21:$E$27,3,FALSE) to
arrive at a result based on the year of the birth date (i.e. if cell I3
contained a ‘1996’ then the result would be ‘U16’).

How would I adjust this formula to handle the new date format in the first
part of this question?

This is part of the table from the “Start†work sheet:

B C D E
21 1993 17 U18 N
22 1994 16 U18 N
23 1995 15 U16 Y
24 1996 14 U16 Y
25 1997 13 U14 Y
26 1998 12 U14 Y
27 1999 11 U12 Y

Thanks,
Kerry

 

[Jacob Skaria]

In Cell J1
=DATE(I1,G1,H1)

=VLOOKUP(YEAR(J1),Start!$B$21:$E$27,3,FALSE)

 

[Ksean]

Works awesome...Thanks!

In Cell J1
=DATE(I1,G1,H1)

=VLOOKUP(YEAR(J1),Start!$B$21:$E$27,3,FALSE)