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
Please Login or Register to view this content.
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
Please Login or Register to view this content.
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:Please Login or Register to view this content.
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