Looking up dates on a separate sheet

[tapsmiled]

Hello,

On Sheet 1 (Data), I have a list of 40 names in column A. Starting in column B, there is a listed date. For each person, there might be only 2-3 dates (each in it's own column) or as many as 30 separate dates.
On Sheet 2 (Leave), Column A is the same list of names, and Row B1 lists every day of the year. I am looking for the formula to place in Leave! that will look for the name on Data! and the dates listed next to that name and place an "X" in the corresponding cell for the date on Leave!.

For example:
Data!
A1 B1 C1
John Smith 1/1/2016 1/5/2016
Tom Allan 1/2/2016 1/3/2016

Leave!

A1 B1 C1 D1 E1 F1
1/1/2016 1/2/2016 1/3/2016 1/4/2016 1/5/2016
John Smith X X
Tom Allan X X


Any help would be greatly appreciated!!

EDITED: My example doesn't look the way I originally wrote it, and I am unable to attach an example.

[davesexcel]

Here is a pic of what your example looks like

tABLEeXAMPLE.JPG

[tapsmiled]

Yes. Thank you so much!

[Tony Valko]

Can you post a SMALL sample file and show us what result you expect?

A SMALL file will have about 20 rows worth of data.

[tapsmiled]

It is exactly what davesexcel posted above. That is how I want the end result to look. The formula should generate the X in each of the corresponding cells on the Leave sheet.

The Data sheet would just look like this:

A B C D E
John Smith 1/1/2016 1/5/2016 1/15/2016 1/25/2016
Tom Allan 1/2/2016 1/3/2016 1/9/2016 1/11/2016
Joan Jones 1/4/2016 1/5/2016 1/9/2016 1/27/2016


I don't have the ability to attach a file from the computer I am on.

[Tony Valko]

See if you can adapt this...

Data Range

	A	B	C	D	E	F
1		1/1/2016	1/2/2016	1/3/2016	1/4/2016	1/5/2016
2	Name1	X				X
3	Name2			X	X
4
5
6	Name1	1/1/2016	1/5/2016
7	Name2	1/3/2016	1/4/2016

This formula entered in B2:

=IF(ISNUMBER(MATCH(B$1,INDEX($B$6:$F$7,MATCH($A2,$A$6:$A$7,0),0),0)),"X","")

Copy down as needed then across as needed.