LinkBack URL
About LinkBacks
dunno its a bit wierd but i guess this
A1 is where your date munber is
MID(A1,4,2)&"/"&RIGHT(A1,2)&"/20"&MID(A1,2,2)
dunno its a bit wierd but i guess this
A1 is where your date munber isMID(A1,4,2)&"/"&RIGHT(A1,2)&"/20"&MID(A1,2,2)
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Just to add to Twiggy's solution, if you want a proper date returned then you can do this:
Formula:
=VALUE(MID(A1,4,2)&"/"&RIGHT(A1,2)&"/20"&MID(A1,2,2))
Format the cell as a date.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks