Hi
I have a work sheet which contains the total yearly expense. I want to allocate this expense for the no of months completed in the year in other sheet.
Eg
Expense sheet row a1 usd 4300/
income expense sheet starting from jan to jul this amount of 4300 need to be proportionaly show for this period as =(4300/12)*7. in aug the no to divide will be 8
what is the formula to use.
Regrds
Shamsu
I have a work sheet which contains the total yearly expense. I want to allocate this expense for the no of months completed in the year in other sheet.
Eg
Expense sheet row a1 usd 4300/
income expense sheet starting from jan to jul this amount of 4300 need to be proportionaly show for this period as =(4300/12)*7. in aug the no to divide will be 8
what is the formula to use.
Regrds
Shamsu