what you are asking is the key to building cashflows and so it’s worth your while having a crack at it yourself – give a man a meal and he eats for a day, teach him to fish and he can build cashflows forever etc etc 🙂
as thegeneralist has alluded to you need to build a formula that checks the location of itself in a calender against the start and stop dates.
So always build a calender along the top and running from left to right, starting a number of columns along to the right so as to give yourself some room for calculation cells in the columns to the left (say, 10 of them. You can hide surplus ones)
Your calendar could be week numbers, or dates, or year numbers, or month or even all of them at once, so plan it out carefully.
finally the amount you want to enter is simply the nth fraction of your total, where n is the number of periods between end and start – an easy formula.
So the formula in a given cell, along the row you want it entered goes something like:
“Check whether DATE at the top of this column is both: greater than or equal to the START DATE and less than or equal* to the END DATE, if the answer is YES, then take AMOUNT and divide by END date minus START date, if the answer is NO then put a zero in here.”
or something like in cell J6:
=IF(AND(J$1>=$H6, J$1<$I6)), $E6/($I6-$H6), 0)
where J$1 is the date at the top of my column, $H6 is my START DATE, $I6 is my END DATE and $E6 is my AMOUNT
HTH
*EDIT have added the EQUAL TO, depending on how you’re using your start and end weeks and whether the cashflow period is inclusive of them or not.