LinkBack URL
About LinkBacks
Is there a way to convert both of these numbers to dates dd/mm/yy or 05/03/12 and 23/02/12
230212
50312
Is there a way to convert both of these numbers to dates dd/mm/yy or 05/03/12 and 23/02/12
230212
50312
this will do the full task:
=TEXT(DATE(2000+RIGHT(A1,2),MID(A1,LEN(A1)-3,2),LEFT(A1,LEN(A1)-4)),"DD/MM/YYYY")
but if you just want to convert to date value so you can work with it and change formating as if it were a typed date, you can use this:
=DATE(2000+RIGHT(A1,2),MID(A1,LEN(A1)-3,2),LEFT(A1,LEN(A1)-4))
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Thanks mate, thats got me sorted for the afternoon, those two had me a bit stuck for a while
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks