Just as an arrayformula in a cell:

PHP Code: 
=TEXT(MAX((C1:C8="1314-HO-038")*(B1:B8<>"")*(B1:B8)),"dd-mm-yyyy") 
in VBA:

cells(6,1)= [text(max(if(C1:C100="1314-HO-038",if(B1:B100="","",B1:B100),"")),"dd-mm-yyyy")]