Hi,
I need to convert a number (i.e., 4-33624-13) to a date. In this case, "4" (first character on the left) is the month and "13" (two characters on the right) are the year. Ideally, it should read as a date, i.e., 04/13 or 04/2013. I've been trying to use the LEFT and RIGHT function, but can't seem to do it as one formula. Any ideas?
Last edited by maryren; 09-19-2013 at 03:47 PM.
Edit- Irrelevant question was here before....
Is the number of characters between the 2 -'s always the same?
Last edited by Jonmo1; 09-19-2013 at 03:36 PM.
try this..
Formula:
Please Login or Register to view this content.
format cell to "mm/yyyy" if reuired..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
yes, the length is always the same
If this is true...
TryOriginally Posted by maryren
=REPLACE(A1,FIND("-",A1),7,"/1/")+0
Format the formula cell as a date of your choice.
Fairbury, USA.. crossing finger.. still if date is not mm-dd-yyyy
then try this also..
Formula:Please Login or Register to view this content.
or this?
=DATE(20&RIGHT(A1,2)*1,LEFT(A1,SEARCH("-",A1,1)-1),1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks