I am using formula =DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)).
When value in A1 = 121505 (six digit number) - formula returns 12/15/05.
When value in A1= 051505 or 51505 - formula returns #VALUE error.
What am I doing wrong, please?
I am using formula =DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)).
When value in A1 = 121505 (six digit number) - formula returns 12/15/05.
When value in A1= 051505 or 51505 - formula returns #VALUE error.
What am I doing wrong, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks