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

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
Asked:
ablove3
  • 2
1 Solution
 
Ejgil HedegaardCommented:
For N2
=INDEX(A2:M2,1,MATCH("U7",A2:M2,0)+1)
copy down.
0
 
aikimarkCommented:
Try this formula in row 2 and fill down.
=INDEX(A2:M2,1,MATCH("U7",A2:M2,0)+1)

Open in new window

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")

Open in new window

0
 
aikimarkCommented:
the Ejgil Hedegaard comment predates mine and should get the points.
0
 
ablove3Author 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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now