Use the formula `=INT(A1)`
Use the formula `=DATE(YEAR(A1),MONTH(A1),DAY(A1))`
Use `=TEXT(A1,”mm/dd/yyyy”)` to display only the date as text
Change the cell format to Date
Change the cell format to Custom and use `yyyy-mm-dd`
Use Find and Replace to remove time values if they are stored as text
Copy the date cells and use Paste Special > Values after applying a date-only formula
Use Power Query to split or transform the datetime column into date only