Hello! I'm constructing a budget, where the first sheet is a overview sheet and 12 other sheets representing all months in a year. I attached an example of the file. The first sheet "Overview" shows one cost category, for which i have set monthly and weekly limits. The numbers should automatically be derived from the second sheet "Jan". There are no problems with showing monthly figures. But i want to be able to keep track of my expenses also on a weekly basis. For example for today (22.01.13), cell C9 on the Overview sheet should show a number of 3,67, because this is the only expense during this week. But, if today would be 19.1.13, cell C9 should show 49,84 (13,61+3,07+33,16). On 20.1.13 C9 should give 53,85 and on 21.1.13 it should show 3,67 (because this is already a new week). Any ideas of what i should do? Thanks
Bookmarks