SOLVED

Converting a number to date

Copper 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

Thanks

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Charl03 Try this:

Screenshot 2021-06-29 at 17.52.44.png

and custom format the cell as yyyy/mm/dd

@Charl03 

As variant

image.png

with

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

@Riny_van_Eekelen 

 

Thank you Riny. 

the formula worked.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Charl03 Try this:

Screenshot 2021-06-29 at 17.52.44.png

and custom format the cell as yyyy/mm/dd

View solution in original post