Looping by weeks...by months

**tmd2** · 01-08-2011, 08:08 PM

Hi,

I have an attached spreadsheet, which has months (January 2011 for example) and the weeks broken out by Thursdays. (1/6/2011, 1/13/2011) Under the months I have a number, what I need to do is find a way to loop through the months, while iterating (looping) by week. Divide that monthly number by 4.25 and have it appear under the week. So 6.12 (26/4.25) would appear for every week in January. I can't iterate simply by four as you can see some months have 5 weeks. I have been at this a while but can't get VBA to quite do it. Sorry if my description is not clear, if you look at the attachment I manually did what i would like to loop through. Thanks, and let me know f you need anything else.

Tom

**protonLeah** · 01-08-2011, 09:58 PM

I don't quite understand your worksheet. The attachment uses worksheet formulas to obtain;

**Marcol** · 01-08-2011, 10:01 PM

Try this in G9

=INDEX($A$9:$D$9,1,MATCH(DATE(YEAR(G6),MONTH(G6),1),$A$6:$D$6,0))/4.25

Drag across to column W

**tmd2** · 01-08-2011, 10:45 PM

Hi protonLeah and Marcol,

Thanks for the replies. Proton...i was giving an example of what I would like to make automatic. Marcol this works great can't thank you enough, I really appreciate it.