Date formula

[Shermaine2010]

My file contain macro.

My formula as below :

IF(O8<>"",IF(ISERROR((MID($B$3,4,2)&"/"&LEFT($B$3,2)&"/"&RIGHT($B$3,4))-(MID(O8,4,2)&"/"&LEFT(O8,2)&"/"&RIGHT(O8,4))),"",IF(((MID($B$3,4,2)&"/"&LEFT($B$3,2)&"/"&RIGHT($B$3,4))-(MID(O8,4,2)&"/"&LEFT(O8,2)&"/"&RIGHT(O8,4)))<=0,"","exceed 3 months")),"")

Formula is correct and i had test it. But it was appear blank at my fren's excel file.

Please advice what is the reason?