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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top