Start date end date calulation

[Schubby10]

Hey guys hoping someone can help me with this. I can play around with dates use helper cells etc.

I have various start dates, end dates and then a PO Amt for each project. I need to straight line all amounts over the time frame.

I currently have 2016/2017 in years and then 2018 by month.

I would like to be able to put the amounts in the coresponding months with a formula.

For example:

K2=PO amount of 834000
L2 = Start Date of 04/01/2018 (can just use 04/18 if easier)
M2= End date of 07/31/2018
N2=2016
O2=2017
P2-AA2=jan-dec 2018

I know the dated formula to get the amount per month but how would I lay this out.

Thank you in advance

 

[Dave Patton]

Excel 2010
	K	L	M	N	O	P	Q	R	S	T	U	V
1	Amount	Start	End	Monthly		Jan-2018	Feb-2018	Mar-2018	Apr-2018	May-2018	Jun-2018	Jul-2018
2	$834,000.00	1-Apr-18	31-Jul-18	$208,500.00		0.00	0.00	0.00	208,500.00	208,500.00	208,500.00	208,500.00
3	$834,000.00	1-Apr-18	31-Jul-18			0.00	0.00	0.00	208,500.00	208,500.00	208,500.00	208,500.00
4
5	T201811b	1c
6
1c

Cell Formulas
Range	Formula
N2	=K2/DATEDIF(L2-1,M2,"m")
P2	=(P$1>=$L2)*(EOMONTH(P$1,0)<=$M2)*$N2
P3	=(P$1>=$L3)*(EOMONTH(P$1,0)<=$M3)*($K3/DATEDIF($L3-1,$M3,"m"))

P1 etc are actual dates like Jan 1 2018

Put N2 where you want or use the formula that calculates the amount in each cell