Convert a sentence in a cell with the American date

grbrck 1 Posts Friday April 21, 2017Registration date April 21, 2017 Last seen - Apr 21, 2017 at 09:13 AM - Latest reply: TrowaD 2286 Posts Sunday September 12, 2010Registration dateModeratorStatus November 7, 2017 Last seen
- Apr 24, 2017 at 12:08 PM
Hello,

I am trying to convert a sentence in a cell with the American date last to the sentence with Canadian date last. ex.
CASH OVER/SHORT 04/01 TO
CASH OVER/SHORT 01/04

And the column will be for the entire month (the top may include a couple days from last month)

Please advise
See more 

1 reply

Reply to this topic
TrowaD 2286 Posts Sunday September 12, 2010Registration dateModeratorStatus November 7, 2017 Last seen - Apr 24, 2017 at 12:08 PM
0
Helpful
Hi grbrck,

Give this formula a try:
=LEFT(A1,LEN(A1)-5) & RIGHT(A1,2) & "/" & MID(A1,LEN(A1)-4,2)

Best regards,
Trowa
Respond to TrowaD