Strip Time from Date in Excel

If you have the time appended to a date in Excel, here's the fix.

Type the following formula into an adjacent empty cell:  =MONTH(cell) & "/" & "/" DAY(cell) & "/" YEAR(cell)

Here's a quick interpretation of the formula:

& = concatenates, or joins together, the elements of a formula
"/" = separates date components and could also be "-" or whatever
(cell) = insert cell address here

Then you'll simply highlight the newly created dates, copy, and paste special values to retain the dates without needing a cell reference or formula at all.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.