nested xlookup

Hello   My input data is   my desired output is    how to achieve this result, basically, i need to get the values for whatever date i enter in the column header. it needs to pull t...