You could use the following.
Date Column A1 = 10/17/2009
Column B1 would be: =MID(A1,1,2)
Column C1 would be: =MID(A1,4,2)
Column D1 would be: =MID(A1,7,4)
*only works if cell format is TEXT.
In Column A, I have a date formatted as follows: 10/13/2007
I want to break this out into three other columns as follows:
Column B Month = 10
Column B Day = 13
Column B Year = 2007
I need all three columns to be values that I can use in a VLOOKUP.
There are currently 2 users browsing this thread. (0 members and 2 guests)