View original (French)

Date conversion from dd/mm/yyyy to yyyymmdd

Solved
Adm82 Posted messages 2 Status Membre -  
 Adm82 -
Hello,

I would like to convert a date 17/03/2015 in Excel to the format 20150317

Thank you in advance!

2 réponses

Réponse 1 / 2
Adm82 Posted messages 2 Status Membre 7
 
Good evening everyone,
I finally received a response from a close friend and it works perfectly. I take this opportunity to share it with you all.

=YEAR(A1)&IF(LEN(MONTH(A1))=1,"0"&MONTH(A1),MONTH(A1))&IF(LEN(DAY(A1))=1,"0"&DAY(A1),DAY(A1))

Cell A1 containing the date to be formatted as desired.

Best regards!
7
Mytå Posted messages 4246 Registration date   Status Contributeur Last intervention   957
 
Hello Forum

Simpler: 
=TEXT(A1;"yyyymmdd"
or
 =TEXT(A1;"yyyymmdd")

Mytå
3
Adm82 > Mytå Posted messages 4246 Registration date   Status Contributeur Last intervention  
 
Bravo !!! It's simpler.
0
joseph
 
perfect and thank you very much!
0