i have a basic table built with dates (jan 1 to jan 31) in colum A and data
in colums B to K. i want to have a weekly total break down at the bottom of
the sheet, i know the easy way to do it is sum the data in to the lower cells
but i want the weekly totals to change every year. Jan 2010, jan 2011 ect.
basicly what i am trying to do is have a Sunday through Saturday total from
the informatin stored in the colloms and rows above it. can it be done?