In this example, we have a date/time value in cell A1 and we'd like to remove the time portion from this value.
In cell B1, we've entered the following formula:
=MONTH(A1) & "/" & DAY(A1) & "/" & YEAR(A1)
The order of how you use the Year, Month, and Day functions will depend on how you're formatting your date.
In this example, we've formatted cell B2 with the following format:
You may need to reorder the Year, Month, and Day functions based on your Date format selected in Excel.
