PC Review


Reply
Thread Tools Rate Thread

Convert string of digits into a date

 
 
Scott Lolmaugh
Guest
Posts: n/a
 
      23rd Feb 2006
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


 
Reply With Quote
 
 
 
 
daddylonglegs
Guest
Posts: n/a
 
      23rd Feb 2006

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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:16 AM.