Looking up a list of names based on the date

Hi,
I have a table where the top row lists the date (1/1/2018 - 31/1/2018) and below in each column is the names of who was at work for that day. I'm trying to make it so that the user can input the date the want to look up and then the spreadsheet retrives and lists the names of who was there below. I'm not sure what formula would work, I've tried vlook up and pivot tables etc. but nothing is working how I need it to. Does anyone have any ideas? tia

I want the layout to be like this:

DATE (input by user)

Person 1
Person 2
Person 3
Person 4
...

Hello and welcome to the forum.

Assuming that the date to be inputted is in Z1, try something like this:

=INDEX(2:2,MATCH(Z$1,$1:$1,0))&""

Drag the formula down as far as needed.

Not sure if the layout works but you could also use the built in slicer function with a pivot table. See attached.

Here is an updated version with an option to manually type in a date.