I am trying to set-up a cashflow statement that will allow users to enter
data against various categories for each day of use: i.e.
01-Jan-05 02-Jan-05 03-Jan-05 04-Jan-05 etc
So in effect users would have a grid to enter their data into.
What I want to be able to do is:
for each of these expenses / revenues, group them first of all weekly
(running Sun-Sat) on a separate sheet, then group them monthly on a separate
sheet, which would allow analysis of weekly / monthly trends.
What is the best way of doing this?
I've managed to do this for the weekly groups by using a combination of the
sum and offset functions (as each week is a constant number of days (7), the
offset function allows me to "jump" across by 7 columns each time). however,
getting something for the monthly groupings is more difficult as each month
obviously varies in the number of days within it.
Any suggestions greatly appreciated,