Extract specific data and convert to a date
Solved/Closed
Related:
- Extract specific data and convert to a date
- Macro to extract specific data from excel - Forum - Excel
- Extract a specific data from a cell ✓ - Forum - Office Software
- Transfer specific data from one worksheet to another for reports - Guide
- Transfer Excel data from one sheet to another: VBA - Guide
- Moving specific data into separate worksheets ✓ - Forum - Excel
2 replies
venkat1926
Jan 23, 2010 at 07:42 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 23, 2010 at 07:42 PM
Your are in that regions where the date is entered as dd/mm/yy whereas the data you have got is from some other regional format(for example my format) where excel date is entered as mm/dd/yy
so you try to use this formula
=(MID(A1,17,2)&"/"&MID(A1,14,2)&"/"&RIGHT(A1,2))+0
and format this as any one of date formats.
so you try to use this formula
=(MID(A1,17,2)&"/"&MID(A1,14,2)&"/"&RIGHT(A1,2))+0
and format this as any one of date formats.