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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- 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
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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