Is there a way convert a date field into 3 columns, with month, year, and day each in separate columns? So that instead of one column with 6/30/201, I could have Month = 6, Day = 3, and Year = 2011?
Is there a way convert a date field into 3 columns, with month, year, and day each in separate columns? So that instead of one column with 6/30/201, I could have Month = 6, Day = 3, and Year = 2011?
This is an easy fix if all dates are formatted the same. If the dates were entered as the format you described above (MM/DD/YYYY), you should highlight the entire column of dates and go into Text to Columns. Before you do this, make sure you have two empty columns for the numbers to shift.
Once you're in Text to Columns, choose Delimited on the first screen and enter / into the Other option. This shifts data to the next column every time there is a /.
Assuming it is a date type and not text, any reason MONTH(), DAY(), and YEAR() aren't working for you?
Pauley
Thanks, both of those worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks