转换日期格式 Microsoft Excel 2007/2010 Convert date/time

中文解释就不必了吧，蛮简单的，有图看！

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.