View original (French)

Date Recognition

Solved
Bestcloever -  
 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 Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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
  2. 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
      1. Bestcloever > fred
         
        Hello,

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

        Looking forward to it,
        Bestcloever
        0