# Date Reformating Question

K

#### 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

J

#### Jacob Skaria

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

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

K

#### Ksean

Works awesome...Thanks!

Jacob Skaria said:
In Cell J1
=DATE(I1,G1,H1)

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