View original (French)

YEAR()

Solved
excel69 -  
 excel69 -
Hello, I don't often use Excel, and here is my problem:
I have different dates in column A (format: day/month/year). In column B, I want to display the corresponding year for each date. So I use the YEAR(A:A) function. However, for some dates, the function works and shows me the year correctly, but for others, I get VALUE#. I can't figure out how to solve the problem
Thank you for your help.
Best regards

Configuration: Windows 7 / Firefox 46.0

3 answers

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 785
     
    Hello,

    Select column A / Right click / Format Cells / Alignment / horizontal: general / Ok
    Widen the column: everything aligned to the right is a date, and everything aligned to the left is text.

    --
    Best regards
    Patrice
    1
    1. excel69
       
      Thank you for the solution, it works.
      0
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    It's that it's not a date recognized by Excel.
    It's either text or <01/01/1900
    eric

    --
    By continually trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to the thank you (yes, it happens!!!), remember to mark it as resolved. Thank you
    0
  3. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    Hello.

    ... and be careful:
    - June 10 2 016 is a text,
    - June 10 2.016 is a text,
    - June 10 2016 is a date!

    --
    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    0