Convert string of digits into a date

's Computer Specifications

I have a date code in the format:
YYMMDDSS
....where "SS" is a sequence number.
I want to extract the day, month, and year data from the string and make a
date that can be used in subsequent date calculations.
Is there a function that would allow me to extract the characters from
position 5 & 6, or 3 & 4, or 1 & 2 that I can then concatonate into a proper
date format?
Thanks,
Scott

's Computer Specifications

Try

=DATE(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2)

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=51598

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert first 6 digits into date	tracktraining	Microsoft Excel Programming	22	7th Jul 2009 07:13 PM
This cell contains a date string rep. with only 2 digits for the y	jdungan	Microsoft Excel Misc	5	5th Jun 2009 05:40 PM
Re: convert string to digits	Ignacio Machin \( .NET/ C# MVP \)	Microsoft C# .NET	2	17th Sep 2004 08:23 AM
Re: convert string to digits	Daniel O'Connell [C# MVP]	Microsoft C# .NET	2	16th Sep 2004 10:42 PM
convert string to digits	=?Utf-8?B?U2FyYWg=?=	Microsoft C# .NET	0	16th Sep 2004 09:19 PM