| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert string of digits into a date
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert string of digits into a date
Try =DATE(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=515987 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Function to convert Time String to Time | Excel Worksheet Functions | |||
| How to COnvert text string to number | Excel Discussion (Misc queries) | |||
| how do I convert a UK date to a US date in excel? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
