Forum Discussion
Excel formula help... again!
I have different tabs for each month. I need the total of the last day of month to start in the opening balance on the next tab in the beginning of the month. but some months obviously has 30 days a...
I just don't understand where my reply went. This is so annoying!
The values changes, I have calculations on the cells in the cows in milk (CIM) row, the calculations are as follow:
previous day minus cows dried off minus CIM died minus CIM sold plus dry cows calved plus heifers calved
the total in the yellow block on the right (CIM row) has to be of the last day of the month and then has to be the opening balance (CIM row yellow block on the left) for the next month as the CIM row calculations will start with the opening balance value.