View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ElFrodo ElFrodo is offline
external usenet poster
 
Posts: 12
Default Still needs help with date formulas

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?