tropics123
Board Regular
- Joined
- May 11, 2016
- Messages
- 85
Hello, I'm hoping someone will have a good solution for this. Our client sends a list of dates and it either has seven or eight digits in column M, depending on the month. The format we want is MM/DD/YYYY.
The formula I have is: =LEFT(RIGHT(M2,8),2)&"/"&LEFT(RIGHT(M2,6),2)&"/"&RIGHT(M2,4)
However, the issue is when the month is a single digit such as May, then it throws off the formula. Please help!
The formula I have is: =LEFT(RIGHT(M2,8),2)&"/"&LEFT(RIGHT(M2,6),2)&"/"&RIGHT(M2,4)
However, the issue is when the month is a single digit such as May, then it throws off the formula. Please help!
Column M | Column N |
Client's Date | Convert Date |
1062020 | 10/06/2020 |
12042017 | 12/04/2017 |
12052019 | 12/05/2019 |
5012017 | 50/01/2017 |
6012007 | 60/01/2007 |