If output of the function is not as per the above (i.e. DATE), then we need to change the cell format. Follow below steps to change the format of the cell:
Step 1: Select the Cell or Data Range
Step 2: Press Ctrl + 1 to open “Format Cells” option
Step 3: Select the option as per below i.e. Date -> 14-Mar-12
Step 4: Click to “OK”