yes - you are doing this incorrectly as none of those functions exists in excel! Why dont you just use cell format to convert it to DATE?
also providing a screenshot of what you do would help understand where else there could be a problem?
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.