I want to convert the date format 10.04.2020 to 10-April-2020.
In my report 10.04.2020 is the default format and it is not accepting this formula =DATE(LEFT(M2,2),MID(M2,3,2),RIGHT(M2,4)).
Please help me or give me a solution.
I want to convert the date format 10.04.2020 to 10-April-2020.
In my report 10.04.2020 is the default format and it is not accepting this formula =DATE(LEFT(M2,2),MID(M2,3,2),RIGHT(M2,4)).
Please help me or give me a solution.
Just set the cell formatting to dd-mmmm-yyyy.
Or this:
=DATE(LEFT(M2,2),MID(M2,4,2),RIGHT(M2,4))
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.
Its not working I want 10-April-2020 format
There are instructions at the top of the page explaining how to attach your sample workbook.
I have attached the excel sheet please insert the formula and test it.
Try this:
=DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2))
Custom formatting for B1: dd-mmmm-yyyy
Excel 2016 (Windows) 32 bit
A B 110.04.2020 10-April-2020
Sheet: Sheet1
Great it worked thanks a lot AliGW.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Or select column "A"
>Ctrl "F"
>In find What enter: .
>In replace with: /
click on replace all
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
The formula you gave is not working it worked for few days but I think there is some change in the format in the system.
I have attached the file for your reference, please help me to get the formula for format 10-Apr-20.
Please refer the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks