View original (French)

Date Recognition

Solved
Bestcloever -  
Hello,

When I am in my Excel data file, the date written is dd/mm/yyyy, but the software only recognizes it when it is entered as yyyy-mm-dd. Is there a way to make a conversion using a formula?

Thank you in advance for your valuable help!

Configuration: Windows / Chrome 59.0.3071.115

2 answers

  1.  Vaucluse Contributor
    Hello

    if Excel does not recognize the date when you format it as DD/MM/YYYY, it is because it is in text format
    try one of these two options
    format your column as dd/mm/yyyy
    select an empty cell / copy it
    select your cell or the field to be processed
    right-click / paste special and "add"

    or
    format an empty column as dd/mm/yyyy
    enter this formula if your "dates" are in A1:
    =A1*1

    or include this calculation in your formulas if you are using A1

    and if that doesn't work, provide an Excel list of your problem here:
    https://www.cjoint.com/

    and come back to paste here the link given by the site

    looking forward to hearing from you
    best regards

    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    1
    1. Bestcloever
      Hello,

      Here is the link to my document:

      http://www.cjoint.com/c/GGzsAvgrixW

      Thank you in advance for your help!
      Bestcloever
      0
      1. fred
         
        Hello Bestcloever,

        Your modified Excel file: https://mon-partage.fr/f/SAp88tob/

        Please let me know if it works for you.

        Best regards
        0
      2. Bestcloever
        @fredHello,

        Yes, that works perfectly! Thank you very much for your help, it is greatly appreciated!

        Looking forward to it,
        Bestcloever
        0