hi,
i have some data in d6:d100, i want to extract date in column(E)
XXXX.jpg
hi,
i have some data in d6:d100, i want to extract date in column(E)
XXXX.jpg
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Try:
=IF(D6="","",SUBSTITUTE(MID(D6,9,8),".","/")+0)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
In E6 copied down:
=DATE(2000+MID(D6,15,2),MID(D6,12,2),MID(D6,9,2))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the reply
Excel Is Just Magic
both formula is working perfectly and many ways to learn the formula use
In E6 anyone of the below formula and copied down:
=MID((TEXTBEFORE(TEXTAFTER(D6,"PAID ON ",1),"--",1)),4,2)&"/"&LEFT((TEXTBEFORE(TEXTAFTER(D6,"PAID ON ",1),"--",1)),2)&"/"&RIGHT((TEXTBEFORE(TEXTAFTER(D6,"PAID ON ",1),"--",1)),2)
=MID((MID(D6,(FIND("ON ",D6,1)+3),(LEN(D6))-(FIND("--",D6,1)-2))),4,2)&"/"&LEFT((MID(D6,(FIND("ON ",D6,1)+3),(LEN(D6))-(FIND("--",D6,1)-2))),2)&"/"&RIGHT((MID(D6,(FIND("ON ",D6,1)+3),(LEN(D6))-(FIND("--",D6,1)-2))),2)
Sekar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks