Resetting Dates

[rwmill9716]

I automatically collect data in Columns D through G for two Factors. I need formula for Columns H and I that match the Factor 2 Date with the Factor 1 Date (Time not important) to begin copying. Here, Rows 6 through 16 would be blank and Row 17 matches the 8/12/16 Date and Factor 2. Note, Row 17 is where I start copying the data in Columns C and D.

Excel 2012
	D	E	F	G	H	I
5	Date/Time	Factor 1	Date/Time	Factor 2	Date/Time	Reset Factor 2
6	8/1/2016 0:55:00	56.25400162	8/12/2016 12:55:45	55.54600143
7	8/1/2016 22:05:43	56.26399994	8/13/2016 0:03:00	56.10800171
8	8/2/2016 23:00:00	56.16999817	8/14/2016 0:03:00	56.2120018
9	8/3/2016 22:00:00	56.29999924	8/15/2016 0:00:04	56.09799957
10	8/4/2016 23:00:00	56.27399826	8/16/2016 6:00:36	56.15000153
11	8/6/2016 0:16:11	56.06100082	8/17/2016 0:21:09	55.92100143
12	8/6/2016 23:48:22	56.22800064	8/17/2016 22:22:01	56.11800003
13	8/7/2016 22:30:00	56.22800064	8/18/2016 23:54:24	56.09199905
14	8/8/2016 23:30:00	56.22800064	8/19/2016 23:15:00	55.97299957
15	8/10/2016 0:03:44	56.10300064	8/20/2016 22:50:00	56.18099976
16	8/10/2016 23:40:01	55.91600037	8/21/2016 23:20:00	56.18099976
17	8/12/2016 1:00:00	56.23799896	8/23/2016 0:05:00	56.27399826	8/12/2016 12:55:45	55.54600143
18	8/13/2016 0:02:00	56.15000153	8/24/2016 0:05:00	56.16500092	8/13/2016 0:03:00	56.10800171
19	8/14/2016 0:02:00	56.13399887	8/24/2016 21:00:00	56.32099915	8/14/2016 0:03:00	56.2120018
20	8/15/2016 0:01:00	56.10300064	8/25/2016 22:30:00	56.29999924	8/15/2016 0:00:04	56.09799957
21	8/15/2016 22:47:52	56.03499985	8/26/2016 22:47:19	56.36800003	8/16/2016 6:00:36	56.15000153
22	8/17/2016 0:20:43	56.00400162	8/27/2016 22:36:15	56.29999924	8/17/2016 0:21:09	55.92100143
Sheet4

 

[etaf]

i can only see a way to use 2 helper columns that turn the date/time to date only using INT()
then you can use a lookup to do what you want there maybe a simplier way

Would added 2 more columns work OK
say
column J INT(A2)
column K INT(F2)

Now you can use for
H
Index($F$2:$F$100, match(J2, $K$2:$K$100,0))

I
Index($G$2:$G$100, match(J2, $K$2:$K$100,0))