Formula help - last date in a range with criterion

[virtuosok]

Hi,
I am likely missing something very obvious... can you tell me what is wrong with the formula as it currently stands? I am trying for it to return the last date with 1 criterion.
Here's the source tab:

...and here's the tab with the formula in cell O10; I expect it to return the value from cell N3 above, i.e. 10 Jan 2020 but it returns zero:

 

[virtuosok]

That's why I said it needs CSE entry.
What is wrong with the MIN formula I provided?

It returns indefinite number of ############### signs (if the cell is formatted as date). Or, if I format the cell to number just to check what's in there, it returns 10,000,000,000

 

[Fluff]

That suggests that there no matches for the value in B10.

 

[Fluff]

If that's the case try

=IFERROR(1/(1/MIN(IF(B10=IWRS002!$H$2:$H$3000,IWRS002!$P$2:$P$3000,""))),"")

 

[virtuosok]

Ok thanks. Let me paste the clips. The MAX formula works perfectly, but the MIN still does not... The last clip (source) is on a tab named IWRS001

 

[Fluff]

Do you have any blank cells in col N where col A is 7?

 

[virtuosok]

Do you have any blank cells in col N where col A is 7?

No, all entries in column A have a corresponding date in column N. In other words, column N has no blank entries. I actually double checked the formatting in column N and it was "general"; however switching it to DD-MMM-YYYY did not change anything in terms of MIN formula output... and then again, it worked for MAX

 

[Fluff]

I actually double checked the formatting in column N and it was "general"

In that case I suspect your dates are text & not real dates.

 

[virtuosok]

Yes I think you're right; these dates are pulled from a third party portal and then pasted "as is".
Is there a way to have a formula addressing this? Or do I need to convert all these text entries into dates? (in which case I think I would need 2 helper columns)

 

[Fluff]

You could try text to columns,
select the column then in text to columns, select delimited, next , uncheck all boxes, next, select DMY from the date drop down, Finish