View original (French)

Date conversion from dd/mm/yyyy to yyyymmdd

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

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

Thank you in advance!

2 answers

  1.
    Adm82 Posted messages 2 Status Member 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
    1. Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   957
       
      Hello Forum

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

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