You can use this formula in B2:
=DATE(20&RIGHT(A2,2),LEFT(A2,FIND(".",A2)-1),SUBSTITUTE(MID(A2,FIND(".",A2)+1,2),".",""))
Format as a date in the style you prefer, then copy down as required.
Hope this helps.
Pete
You can use this formula in B2:
=DATE(20&RIGHT(A2,2),LEFT(A2,FIND(".",A2)-1),SUBSTITUTE(MID(A2,FIND(".",A2)+1,2),".",""))
Format as a date in the style you prefer, then copy down as required.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks