Reference look up with Date Associations

[kparadise]

Hello,

On [Sheet 1] I have a listing of certain Customers, Customer IDs, and Times within my population. On [Sheet 2] I have a complete listing of all the Customer IDs and an Event Time.

[Sheet 1]

Customer	Customer ID	Time (TIMESTAMP)	Looking to see if a Event Time occurred within 180 days prior to the [Time] column (column C).	Looking to see if a Event Time occurred within 4 days after the [Time] column (column C).
Mr X	1	12/13/2017 9:21 AM	Y	N
Mr XX	2	12/13/2017 10:33 AM	N	Y
Mrs Y	3	12/13/2017 8:56 PM	N	Y
Ms Z	4	12/13/2017 2:31 AM	Y	Y

<tbody>
</tbody>

[Sheet 2]

Sheet 2 contains every single record of each of the four Customer IDs and the Event Time.

Customer ID	Event Time
1	12/13/2017 9:20 AM
1	8/4/2016 10:22 AM
1	6/12/2017 5:35 PM
2	1/1/2018 11:24 AM
2	12/15/2017 8:59 PM
2	2/12/2018 6:35 AM
3	12/14/2017 4:55 PM
4	9/1/2017 7:33 AM
4	12/16/2017 8:10 AM

<tbody>
</tbody>

So what I am asking is to create to column on [Sheet 1] - the ones with bold headers. Look at each record on [Sheet 1]; and tell me if, for that said Customer ID, they had an event happen within 180 days prior to the [Time] column. Also, look at each record on [Sheet 1]; and tell me if, for that said Customer ID, they had an even happen within 4 days after the [Time] column.

I hope this make sense.... Time is a factor as well.