LinkBack URL
About LinkBacks
Hi All,
I need a formula to correc the date format in the cell.
I have attached the excel sheet for your reference.
Thanks in advance
Hi All,
I need a formula to correc the date format in the cell.
I have attached the excel sheet for your reference.
Thanks in advance
No need for a formula.
1. highlight the range with the dates in it
2. click Home tab/Data Tools/Text2Columns
3. click next/next check Date and select your required date format
4. click Finish
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi...I got it..this dates has been fetched by some tools / software...Originally Posted by Excel_Pa
Can you try the below formula in E3.. it should work
=IF(A3="","",IF(ISTEXT(A3),(MID(A3,FIND("/",A3)+1,FIND("/",A3,FIND("/",A3)+1)-FIND("/",A3))&LEFT(A3,FIND("/",A3))&RIGHT(A3,2))+0,DATE(YEAR(A3),DAY(A3),MONTH(A3))))
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
Happy to help, thanks for the feedback
Glad it worked ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks