Monthly Budget

Dear Friends

Herewith I attached a file named `Monthly Budget'.

In that file sheet name `Datas' contain columns `Date', `Credit / Debit' and `Value'

I want a report in `Report' sheet in yellow color cells as per month and year, Total Credit / month and Total Debit / month

Thanks in advance

thilag

Notes :

* The values should be generated for Both Month and Year eventhough we input only dates.
* The Date will not be random like that. It will not be in order
Example : first date may be 20-Oct-2013 last may be 06-May-2013
* The values entries will not unifrom and it is according to our expenditure
Example : April 2013 may have 10 entires and May have only 2 entries
* Also the Credit and Debit entries for same month may ot maynot be unique
Example : In June 2013 Credit entries may be 5 and debit entry may be equal or more than 5
* Yellow color cells to be filled by formula

Maybe something like this? hope it helps you


Azumi

Thanks to Azumi and benishiryo. This helps me to calculate the day to day expenses in Month wise

thanks

thilag