Convert a sentence in a cell with the American date

Closed
grbrck Posts 1 Registration date Friday April 21, 2017 Status Member Last seen April 21, 2017 - Updated on Apr 21, 2017 at 04:22 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Apr 24, 2017 at 12:08 PM
Hi grbrck,

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

Best regards,
Trowa
0