View original (French)

Remove the day from a date

Solved
Nick2809 Posted messages 6 Status Member -  
Nick2809 Posted messages 6 Status Member -
Hello,

In Excel, I have a table with dates (yyyy-mm-dd). I would like each of these dates to become yyyy-mm. However, I do not want to keep the day in memory.

For example: 2015-04-17 -------> 2015-04 (I do not just want to change the format)

Thank you in advance for your help
Anick

1 answer

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello, 

    =TEXT(A2,"yyyy-mm")

    but it will no longer be dates, so no more calculations possible with it.

    eric

    --
    By trying continuously, we end up succeeding. So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to saying thank you (yes, it is done!!!), remember to mark as resolved. Thank you
    0
    1. Nick2809 Posted messages 6 Status Member
       
      Thank you very much!!!! It works!
      0