Logical_test on Dates to get date_wise MIN and MAX values

Put this array* formula in B2 of the Summary sheet:

=MIN(IF(Date_wise_MIN_MAX!$A$2:$A$28516=A2,Date_wise_MIN_MAX!$C$2:$C$28516))

and this array* formula in C2:

=MAX(IF(Date_wise_MIN_MAX!$A$2:$A$28516=A2,Date_wise_MIN_MAX!$C$2:$C$28516))

then copy down.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual < Enter >.

Hope this helps.

Pete