Hi there,

I saw there are some weeknum question already floating around but I couldn't find one similar to my situation.

I have an ongoing quarterly report where I need to take dates from one report and generate which week in the quarter the date falls into. Example and details below.

Quarter start date varies. Current quarter starts on 5/1/2011
Quarter end date varies. Current quarter ends on 7/30/2011 (not sure if this matter. I can always reset the start date)
Week start dates are Sundays
The date format's I'm using are for example 3/14/2011
One other catch is I need to factor in a week 0. That is, any dates that are before the first week of the quarter need to be week 0.
Date range is A2 to A50 or so...

An example of the above situations would be:
3/14/2011 is week 0
5/3/2011 is week 1
5/10/2011 is week 2
and so on...

If you could also explain how I can update the formula to work in the future with different quarter start dates I would extremely appreciate it. Maybe referencing a cell where I put the quarter start date?...

Thanks for any help you can give. I tried giving as much information as possible but if I left anything out let me know.

Thanks again!