Convert date in calculated column

[referee]

hi

hwo can i in a list convert a date to
year-week and daynumber ?

example date : 5/01/2009
I want a calculated column that shows me the date like

200921

2009 YEAR
2 WEEKNUMBER
1 DAYNUMBER

can someone help me with that

thanks and happy holidays

frank

[Andreas Kviby]

Hi
You can use YEAR, WEEK and DAY like this.

=YEAR(Column1) & WEEK(Column1) & DAY(Column1)

I havent tried it and it also requires the date stored in Column1 as the sample uses it as the input date.