I have a date in Col A1 as 17 January 2020 I want to extract this in B1 as 17/01/2020
I used a formula below but get an incorrect answer
![]()
=DATE(LEFT(A1,2),MONTH(1&MID(A1,4,2)),RIGHT(A1,4))
It would be appredciated if someone could assist
I have a date in Col A1 as 17 January 2020 I want to extract this in B1 as 17/01/2020
I used a formula below but get an incorrect answer
![]()
=DATE(LEFT(A1,2),MONTH(1&MID(A1,4,2)),RIGHT(A1,4))
It would be appredciated if someone could assist
The date in A1 is not text, It is formatted to look like text.
Change format in cell, or use this formula:
Formula:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Good luck!
Thanks for the help
You're welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks