ashishpatel34
New Member
- Joined
- Apr 18, 2019
- Messages
- 2
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.
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.