Extracting date from a series of numbers
Solved/Closed
seekermay
Posts
28
Registration date
Wednesday January 27, 2010
Status
Member
Last seen
May 27, 2013
-
Feb 9, 2010 at 06:11 AM
Santos - Jul 14, 2010 at 01:51 AM
Santos - Jul 14, 2010 at 01:51 AM
Related:
- Extracting date from a series of numbers
- Best scandinavian crime series on netflix - Guide
- Apple watch series 9 release date - Guide
- Audio track download for series - Guide
- Xbox series x 3d blu ray - Guide
- Hitman 3 cheats xbox series x - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2010 at 09:01 AM
Feb 9, 2010 at 09:01 AM
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
Format it to the way you want as this is a date to excel and not some thing that looks like a date
Format it to the way you want as this is a date to excel and not some thing that looks like a date
seekermay
Posts
28
Registration date
Wednesday January 27, 2010
Status
Member
Last seen
May 27, 2013
5
Feb 9, 2010 at 01:56 PM
Feb 9, 2010 at 01:56 PM
thanks! It works.
Jul 14, 2010 at 01:51 AM