Hi all,
after couple of days I have realized, that I have incorrect functon for text conversin to date.
=DATE((RIGHT(E2,4)),(MID(E2,3,2)),(LEFT(E2,2)))
I need to change text to date format as follow: D.M.YYYY.
However, when I have text format as DD.MM.YYYY formla is working properly, on th eother way nope. DO you know, how to change the functoin?
Thanks
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
ampe workbook added
Try this
Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
it's a bit complex to locate 2 dots "." in the date to be converted. function is constructed as follows,
Formula:Please Login or Register to view this content.
Or perhaps
=DATEVALUE(SUBSTITUTE(A2,".","/"))
thank you so much, working :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks