Convert a sentence in a cell with the American date

[Closed]
Report
Posts
1
Registration date
Friday April 21, 2017
Status
Member
Last seen
April 21, 2017
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi grbrck,

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

Best regards,
Trowa