Use year and weeknr to find date??
 

Is there a formula to automatic fill out the right corresponding dates, or
other ways to do it??
I.e.
a1=2007 (year)
b1= 2 (week nr)

and in c1-c7 i want it to automaticly to say 8, 9, 10 and so fort.

Can enyone help me??

Use year and weeknr to find date??
 

C1 =DAY(DATE($A$1,1,1)-WEEKDAY(DATE($A$1,1,1),1)+7*$B$1-5)+ROWS($1:1)-1

Fomat cell as general
Drag the Fill Handle from C1 to C7


"ElFrodo" wrote:

Is there a formula to automatic fill out the right corresponding dates, or
other ways to do it??
I.e.
a1=2007 (year)
b1= 2 (week nr)

and in c1-c7 i want it to automaticly to say 8, 9, 10 and so fort.

Can enyone help me??

Use year and weeknr to find date??
 

Thans :)

Teethless mama skrev:

C1 =DAY(DATE($A$1,1,1)-WEEKDAY(DATE($A$1,1,1),1)+7*$B$1-5)+ROWS($1:1)-1

Fomat cell as general
Drag the Fill Handle from C1 to C7


"ElFrodo" wrote:

Is there a formula to automatic fill out the right corresponding dates, or
other ways to do it??
I.e.
a1=2007 (year)
b1= 2 (week nr)

and in c1-c7 i want it to automaticly to say 8, 9, 10 and so fort.

Can enyone help me??