Converting a number to date

New Contributor

I'm stuggling to convert the following numbers to dates. Can you perhaps suggest a formula or work around.

20181011 needs to be converted to 2018/10/11

20190620 needs to be converted to 2019/06/20


3 Replies

@Charl03 Try this:

Screenshot 2021-06-29 at 17.52.44.png

and custom format the cell as yyyy/mm/dd


As variant



=DATE(A1/10000, MOD(A1,10000)/100, MOD(A1,100))



Thank you Riny. 

the formula worked.