Assuming those text strings are in A2 going down:
B2: =DATEVALUE(MID(A2,3,2)-70 & "/" & MID(A2,5,2) & "/" & CHOOSE(MID(A2,2,1)+0,,, 2013, 2014))
(format cell as Date)
C2:...
 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
Search:
Type: Posts; User: JBeaucaire
Search: Search took 0.03 seconds.
-
Nov 14, 2013, 02:11 PM
Question: Create date from custom text string in excel
by JBeaucaire- Answers
- 3
- Views
- 2,284
Assuming those text strings are in A2 going down:...
-
Nov 14, 2013, 08:26 AM
Question: Create date from custom text string in excel
by JBeaucaire- Answers
- 3
- Views
- 2,284
Provide an example text string and the resulting...
Provide an example text string and the resulting date that would be derived from it, provide one for EVERY month of the year and include several years as well. Show us all the variations. I can't...
Results 1 to 2 of 2
|
