• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert to date

Belleke

Belleke

Well-Known Member
In cell I have AB18101XXXXX
AB is not inportant.
18 is Year
101 is day of the year
XXXXX is not inportant
In the offset(,1) cell should be the date.
11/04/2018 in this case
Thanks in advance.
 
Belleke
B3 is Your 'cell'
You could use this:
=DATE(2000+MID(SUBSTITUTE(B3,"X",""),3,2)-1,12,31)+ MID(SUBSTITUTE(B3,"X",""),5,99)
 
Hi Vletm,
Thanks for your time.
This is what i was looking for.
=DATE("20"&MID(B3,3,2),1,1)+(MID(B3,5,3)-1)
 
hmm...?
How would that work, if You try to get 2nd day of that Year? (AB181XXXXX)
... or would there be some rules of that which You would like to convert?
All matters!
 
You must log in or register to reply here.
Back
Top