How to find next scheduled date of employee

1. Change the dates in schedule to real dates.

2. To return the next DATE:
=IFERROR(INDEX(Schedule!$B$1:$H$1,MATCH(1,(Schedule!$B$1:$H$1>=TODAY())*(INDEX(Schedule!$B$2:$H$6,MATCH(A2,Schedule!$A$2:$A$6,0),)<>"Off"),0)),"")

3. To return the next TIME:
=IFERROR(INDEX(Schedule!$B$2:$H$6,MATCH(A2,Schedule!$A$2:$A$6,0),MATCH(C2,Schedule!$B$1:$H$1,0)),"")

Obviously, if you want the search to EXCLUDE today, remove the bit in red from the fromula at 2).