Abhijeetji Technical 4M
1 год назад
Комментарии:
Why have you right 5 in the formula with MID? I mean what's the logic?
You can Simply use this formula :- =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))