date form

[mario-sarkis]

Hey all

any idea if I want to Transfrom

number to date form example :

"42467" should look like this : "20160407".

Thank you,

[rahulpawarb]

Hello Mario,

Please use below:

=Date(42467, 'YYYYMMDD')

Hope this will be of help.

Regards!

Rahul

[Anonymous]

Hi,

=Date(42467,'which ever date format you want')