Hi Aditya

Welcome with another date query !!

If you are sure your data do not have future dates....then use the below
which will consider the century as 19 for any year above current year. If
less than current year century 20 is considered..

=DATE(IF(RIGHT(RIGHT(A1,6),2)RIGHT(YEAR(TODAY()), 2),"19","20")&RIGHT(RIGHT(A1,6),2),MID(RIGHT(A1,6) ,3,2),MID(RIGHT(A1,6),1,2))6),2)

If all dates are in 20 th century then try
=DATE(2000+RIGHT(RIGHT(A1,6),2),MID(RIGHT(A1,6),3, 2),MID(RIGHT(A1,6),1,2))


If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

Data in column A is of 8/9/10 or 11 digit.
However in every case last 6 digit is in form of ddmmyy. how can i get date
from this in column B.