Column contents

Michael Herkner

Hi all,

is it possible for the calendar week to be displayed in a column?

bg Michael

Dale Murphy

@Michael Herkner Have you tried =WEEKNUMBER( date )

Dale

Michael Herkner

Hi Dale,

THX. how does the reference to another cell work

I have a "beginning" column in which there is a date, i like an extra column displayed the date as weeknumber.

=Anfang@row (WEEKNUMBER)???

Mike

Michael Herkner

OK i got the answer.

=WEEKNUMBER(Anfang@row)

and th column must be "text/number"

THX