The exact above did not work, but I ended up with the formulas below and it worked!! Wooo Hooo!!
=IF(MIN(IF($B4&$C$3=REGION1&SLA1,CONTACT_DATE1)),MIN(IF($B4&$C$3=REGION1&SLA1,CONTACT_DATE1)),"")
and for VBA
[SLA4_REG_7988].Select
Selection.FormulaArray = _
"=IF(MIN(IF(R4C2&R3C3=REGION1&SLA1,CONTACT_DATE1)),MIN(IF(R4C2&R3C3=REGION1&SLA1,CONTACT_DATE1)),"")"
[SLA4_REG_7988] = [SLA4_REG_7988].Value
Thank you so much!!
Bookmarks