Try with =DATEVALUE() else post a sample in excel