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
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