Wow.. Just found the solution. How silly. I'm using a computer with Dutch Excel.. Year means Jaar.. The right format was jjjjmmdd. Both of your soluions worked when I used J instead of Y.

So many thanks for your help! <3