Use year and weeknr to find date??

E

ElFrodo

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??
 
T

Teethless mama

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
 
E

ElFrodo

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
Click to expand...
 
Top