Let me begin by apologizing for posting the same question twice. For some
reason, I am unable to locate the original and the notification sent to me by
Microsoft about a response was linked to a blank page.

I am using Office 2007 and I need to be able to have a dynamic table based
on fiscal months of the year. I have created a file that sums sales and open
orders based on date by fiscal month. The first sheet shows a 5 rolling
months with subtotals by week within each fiscal month. This information is
pulling from two additional sheets that are linked to an outside source.
This was working great until we came upon the new fiscal year. Can someone
help? I am using sumproduct to gather my totals because there are multiple
criteria to be met, as well as I was using if statements with the sumproduct
to determine the months. I have a worksheet in the file that is dedicated to
fiscal months showing dates for each. I have a column that indicates which
month number it is of the fiscal year (ie July is 1, August is 2 and so on).