LinkBack URL
About LinkBacks
Assuming your current data is text and not a formatted date, then with data in A2 try this formula in B2
=MID(REPLACE(A2,FIND(" ",A2,FIND(" ",A2)+1)-2,2,""),FIND(" ",A2)+1,99)+0
Format B2 in required date format
Assuming your current data is text and not a formatted date, then with data in A2 try this formula in B2
=MID(REPLACE(A2,FIND(" ",A2,FIND(" ",A2)+1)-2,2,""),FIND(" ",A2)+1,99)+0
Format B2 in required date format
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks