Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the size of the text box in a flow chart? | Charts and Charting in Excel | |||
XIRR | Excel Worksheet Functions | |||
Is there a function to caluclate convexity of bond given cash flow | Excel Worksheet Functions | |||
Cash Flow Analysis | Excel Discussion (Misc queries) | |||
Vlookup and Indexing in excel | Excel Worksheet Functions |