Even Date Distribution Across Array

[bnd21]

Hi-

I am trying to populate dates in a range of cells based on a number in a different cell. This is for a proposed condominium sell out schedule.

For example, if:

Cell A1 (start date): 9/1/2012
Cell A2 (Sell out period length): 15 months


I would like Cells C2:C34 (each row being a different condo unit) to automatically have an even distribution of the months between the start date and the last month of the sell out period.

Thanks very much for your help.

[martindwilson]

what would want it to look like post a sample workbook easy way to create a series of months based on those 2 conditions is in c2 dragged down
=IF(ROW(A1)>$A$2,"",EOMONTH($A$1,ROW(A1)-2)+1)
if you want every month repeated twice then
=IF(ROW(A1)>$A$2*2,"",EOMONTH($A$1,CEILING(ROW(A1),2)/2-2)+1)
here are 4 ways

[bnd21]

Thanks for the response. Here is a sample. Columns are a little bit different. The highlighted cells in Column K are the destination cells. Essentially would like to assume a certain amount of units/month sold, evenly dividing them over the amount of months from Cell A1 and Cell A2.

Thanks again.

[martindwilson]

says 12 but only 11 months covered

[shg]

Perhaps in K3 and copy down,

=INT($A$1 + (EDATE($A$1, $A$2) - $A$1) * (E3-1) / 32)

[bnd21]

Perhaps in K3 and copy down,

=INT($A$1 + (EDATE($A$1, $A$2) - $A$1) * (E3-1) / 32)

This could work I think. Any way I can make the dates it returns default to the first day of that month? So K4 would be 2/11/2014, I would like it to default to 2/1/2014.

Thanks.

[bnd21]

Nevermind, looks like this works. Just used =eomonth( around the whole thing to have it return to the first day of the month.

Thanks alot, this was bothering me for a while.