Lookup Min And Max Dates From Series Of Dates With Blanks

I have two worksheets in which I am trying to get the blue bold data (not text) derived from a formula.

Main

A
B
C
1
Site #
First Apt Date
Last Apt Date

[Code]....

Apt Report (month/day/year)

A
B
1
Site #
Apt Date
2
1001

[Code]....

I have some restrictions:
I cannot alter the format of Main, except I can add columnsI cannot alter at all the data or format on Apt Report (I cannot sort, filter, pivot, add columns...etc)

Any way for Main to look at Apt Report and give me the earliest and latest appointment?

I have tried the DMIN function but am limited it seems to being able to change Main to accommodate it. I have tried an array with MIN(If but ran into issues with the cells on Apt Report that are blank...it would return those as the earliest appointment....albeit it is correct...but not what I need!!!

The Apt Report will continually be updated to, so I need to be able to search the entire Apt Date column.