Forum Discussion
MrStern
Jun 15, 2023Copper Contributor
correcting date presented as general figures
I am looking for help on formatting dates in excel. The system that spits out my data puts the date out in 'general' format. E.g. for January 2023 it will say 202311 (meaning 2023/01/01) for Dec...
MrStern
Jun 15, 2023Copper Contributor
=DATE(LEFT(A2,4),LEFT(MID(A2,5,9),LEN(MID(A2,5,9))-1),1) where A2 is the date
SergeiBaklan
Jun 15, 2023Diamond Contributor