Need fast Arrayformula for index match


I create an index match formula that copy down all the way to 1000 rows. That makes it so slows. Is a way to speed it up? M2 match to range $B$2:$B$1000 is a datetime and match type is 1


Thank very much


@desmondlee do you have a live example to play with?