Format Date  
 
 

Change the date formats easily using the Format Date tool . Click many times to see other types of date formats.
 

 
Format settings
 
 
 
 
Note:
This function is available in excel 2007 and above.