magci conversion date expires and modified date in sharepoint

=TEXT(A2,"dd/mmm/yyyy")
or
=TEXT(A2,"dd/mm/yyyy")

credit goes to
http://www.ozgrid.com/forum/showthread.php?t=61117&page=1