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
 

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

Similar Threads

Adding Filtering to a Rating Equation? 0
1 Column 'Date' to 3 Seperate Columns 'Month, Day, Year' How?? 0
VBA format of cells with colour based on IF formula 2
Cond. Form. Adding In dates & out of dates 0
If functions and Vlookups combined 5
date of birth age formula 8
VLOOKUP over three spreadsheets 8
Error message: This file is corrupt and cannot be opened 3

Top