Formula help

[Kclynn]

I need the very next cell in the row to be the difference left between the sum of the previous cells in the row.

ISDProjectedGrossMargins2020_3_27.xlsx
	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
56	Recognize		Funded	%	Book	Mos.	Dec	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Sep-20	Jan-00	Dec-20
57	200,000	0		30%	7/19	7
58		0	Y	330%		4
59	21,000	0		20%	6/19	4
60	128,000	128,000		99%	3/20	6		0	0	13,653	13,653	13,653	13,653	13,653	13,653	0	0	0	0
61	530,000	530,000		70%	4/20	7		0	0	0	48,457	48,457	48,457	48,457	48,457	48,457	48,457	0	0
62	350,000			35%	5/20	6		0	0	0	0	37,333	37,333	37,333	37,333	37,333	37,333	0	0
Projected Margins 11x17 (2)

Cell Formulas
Range	Formula
R60:AC62	R60	=IF(AND(R$56>=$O60,R$56<EDATE($O60,$P60)),(($K60/$P60)*0.64),0)
L57:L61	L57	=IF($C57<>"D",K57,0)

 

[jasonb75]

Ah, I had to change the dates to work with UK regional settings so had corrected it already without realising.