Monthly update difference

[runeyjam]

I have a spreadsheet I have to update each month. The last column in the spreadsheet calculates the difference btw the current month and the previous month. Is there any way to automate this process so I do not have to change the formula each month. Here is a sample of my spreadsheet:

Moving difference.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Current Month	8													Move
2		All figures in US$ millions	1	2	3	4	5	6	7	8	9	10	11	12	MTD
3
4		Loans and Advances to banks	5,973	5,520	5,515	4,318	5,195	4,461	3,539	4,437					898
5		Debt securities	4,750	4,640	4,713	4,805	4,337	3,970	4,769	2,595					(2,174)
FM Balance Sheet

 

[Oaktree]

Try:

O4 = OFFSET(B4,0,COUNTA(C4:N4))-OFFSET(B4,0,COUNTA(C4:N4)-1)

P4 = OFFSET(B5,0,COUNTA(C5:N5))-OFFSET(B5,0,COUNTA(C5:N5)-1)