I have a workbook with three sheets - Data, VisitDate1, and VisitDate2.
VisitDate1 takes the date from "Data": =INDEX(Data!H3:R3,MATCH(TRUE,INDEX((Data!H3:R3<>0),0),0)).
The result looks like this:
<tbody>
Mon, Sep 10, 2018
8:30AM - 2:00PM
</tbody>
VisitDate2 should take that date and...