Date Reformating Question
 

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

Date Reformating Question
 

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

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

--
Jacob


"Ksean" wrote:

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

Date Reformating Question
 

Works awesome...Thanks!


"Jacob Skaria" wrote:

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

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

--
Jacob


"Ksean" wrote:

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