How to pick out dates. In Excel

I want to pick out “Month/day” from string like “2023/7/13 0:31:19”.
I tried to it by using a function,LEFT() and RIGHT(),
but it didn’t work.
For example

Number A B
1 2023/7/13 0:31:19 RIGHT (A1,5)

I guessed B1 would be “31:19”,but it was practically
Please tell me how to pick out.

>Solution :

Try this


Leave a Reply