Actual Sales phasing

[AliBb]

I have a table of data with the following headings
Value - Months - StartDate - 1/5/19 - 1/6/19

I want to automatically forecast out the monthly value based on the start date for eg
1000 - 10 - 1/7/19
2500 - 20 - 1/6/20

Row 1 would have values in each column starting 1/7/19 - 1/4/20 ie 10 columns of 100 with 0 in all others

Row 2 would have values in each column starting 1/6/20 - 1/1/22 ie 20 columns of 125 with 0 in all others

What formula can I use or how best would it be to get this data

 

[jtakw]

Hi,

If I understand your description correctly, this would do it.
I changed your SECOND row START date, VALUE, and MONTHS so the sample table will fit on screen:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Value	Months	StartDate	1/5/19	1/6/19	1/7/19	1/8/19	1/9/19	1/10/19	1/11/19	1/12/19	1/1/20	1/2/20	1/3/20	1/4/20	1/5/20	1/6/20	1/7/20	1/8/20	1/9/20
2	1000	10	1/7/19	0	0	100	100	100	100	100	100	100	100	100	100	0	0	0	0	0
3	2400	15	1/6/19	0	160	160	160	160	160	160	160	160	160	160	160	160	160	160	160	0
Sheet29

Cell Formulas
Range	Formula
D2	=IF(AND(D$1>=$C2,EDATE($C2,$B2)>D$1),$A2/$B2,0)

D2 formula copied down and across as far as needed.

 

[AliBb]

Thank you

 

[jtakw]

You're welcome, welcome to the forum.