• Status: Solved
• Priority: Medium
• Security: Public
• Views: 53

# Rehire Date Extract

I download a table that has many service dates, but I only need the U7 Rehire date.  The problem is that for various employees, that U7 date might be in different Columns.

I need a formula that will only return the U7 date in one column
Rehire-date-extract.xlsx
0
ablove3
• 2
1 Solution

Commented:
For N2
=INDEX(A2:M2,1,MATCH("U7",A2:M2,0)+1)
copy down.
0

Commented:
Try this formula in row 2 and fill down.
=INDEX(A2:M2,1,MATCH("U7",A2:M2,0)+1)
Note: you will need to format the column as a date

or
=TEXT(INDEX(A2:M2,1,MATCH("U7",A2:M2,0)+1),"m/d/yyyy")
0

Commented:
the Ejgil Hedegaard comment predates mine and should get the points.
0

Author Commented:
Aikimark, you are a good person and have always been there for me. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.