I read text as dates

[#1]

However the year comes up like 56989 . What am I doing wrong?

[Gysbert_Wassenaar]

Probably using the wrong date format string. Post the text of a date here and somebody can show you what to use.

[#3]

20140518

20140702

20140911

This an example of the format I try to read as Date (Periode) as Periode,

[#4]

I doesn't really show here but in the excel sheet the numbers are stored as text.

[Gysbert_Wassenaar]

Date will treat the number as the number of days since 31-12-1899. What you need is to treat Periode as a string using the date# function: date#(Periode, 'YYYYMMDD')

[#6]

That worked 100% .. Thanks!!!

[#7]

However there is a 0 at the top for all the missing cases...

[andrewpettit]

If you only want the year from the format you provided why not simply do "Left( Periode , 4 )"?

[#9]

I will check it out when I got time! Thanks