MEDIANIF formula for date up untill TODAY() in Excel

I'm Trying to calculate the median value (Column D) for any date in the past and today (Column B). I've been successful calculating the Average of the same data using AVERAGEIF but there doesn't seem to be an equivalent in Excel.

I used =AVERAGEIF(B11:B1569,"<=" & TODAY(),D11:D1569) successfully.

But when I use a MEDIAN(IF Array =MEDIAN(IF(B11:B1569<=TODAY(),D11:D1569)), I get a different answer than is I just manually did it =MEDIAN(D11:D1569)

Thanks