Cash Flow Set-Up
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. |
All times are GMT +1. The time now is 08:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com