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