| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert weeknr to a date | Excel Worksheet Functions | |||
Threaded Mode
