Date data imported from other systems can include times. This can make lookup and other calculations difficult. One function can make removing or extracting time easy.
Date are numbers in Excel. Times are fractions of a day, so .5 is noon and .75 is 6PM.
To remove a time from a date you can use the TRUNC function which removes all decimals.
The formula in cell C2 is
Both cells have been formatted to display the correct results. The image below has the all formats removed.