Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My initial question was as follow below:
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 automatically to say 8, 9, 10 and so fort. Can anyone help me?? I got the following answer from teethless mama: C1 =DAY(DATE($A$1,1,1)-WEEKDAY(DATE($A$1,1,1),1)+7*$B$1-5)+ROWS($1:1)-1 Format cell as general Drag the Fill Handle from C1 to C7 Witch helped a lot, but didnt quit get me there. This formula count to 31 and therefore when I use it in February (witch only has 28 days) it doesnt start at 1 again at the right day. My problem is that I am only gone use 1 sheet whit 4 week columns (with 7 days column for every week) and change the week number and then get the right date just from the year and week number. So please anyone, can I get some more help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Date formulas needed | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |