MS Excel 2011 -- Change Date Time field to Date

Change the date time field to date, do the following in the cell

=Text(B2, "yyyy-mm-dd")


B2 is the cell with date time field.