LinkBack URL
About LinkBacks
Put the 12 months of the year in a range somewhere else, and name it Months.
Then, if the date's in A2, B2 can be
=DATE(2012,MATCH(RIGHT(A2,LEN(A2)-FIND(" ",A2,FIND(" ",A2)+1)),Months,0),MID(A2,FIND(" ",A2)+1,2))
Put the 12 months of the year in a range somewhere else, and name it Months.
Then, if the date's in A2, B2 can be
=DATE(2012,MATCH(RIGHT(A2,LEN(A2)-FIND(" ",A2,FIND(" ",A2)+1)),Months,0),MID(A2,FIND(" ",A2)+1,2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks