Attached is a sample of an income and expenses report (1st tab), and month-end cash balance report (2nd tab), that I maintain.
Right now, I am using “=Report!E12” to record the cash balance for the month of January 2012. This manual method is tedious and potentially can create an error if not careful.
I have been researching the internet for an excel formula of a cash balance for a specific month and year.
Can anyone help me, please