G
Gary T
Hi,
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
Revenue:
Sales
Rental Income
etc
Expenses:
Rent
Overheads
Miscellaneous
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,
Regards,
Gary T.
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
Revenue:
Sales
Rental Income
etc
Expenses:
Rent
Overheads
Miscellaneous
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,
Regards,
Gary T.