Excel Spreading dates evenly in a row of cells
 

I have a start date in Cell A1-Dec 1, 2008
I have a complteion date in cell A10-Dec 30,2008
I need the cells A2-A9 to reflect the dates spread out evenly amongst them.

Excel Spreading dates evenly in a row of cells
 

In A2 enter:
=A1+($A$10-$A$1)/9 and copy down. Then format as date.
--
Gary''s Student - gsnu200838


"OHNESORGE" wrote:

I have a start date in Cell A1-Dec 1, 2008
I have a complteion date in cell A10-Dec 30,2008
I need the cells A2-A9 to reflect the dates spread out evenly amongst them.

Excel Spreading dates evenly in a row of cells
 

K now its getting more compilcated,
1st ty for the answer.
2nd As i try to evolve the spread sheet. under the cells A2-A9 i have when
they were completed. EX-C2=12/7/08, C3=12/8/08= C4=(1), that is fine. my
problem is where i have not entered a completion date it is showing the
number date value. EX D2=12/10/08, D3= no # inputed yet, D4= displays 39793
Question is how do i make D4, not display a number until one is inputed in D3

"Gary''s Student" wrote:

In A2 enter:
=A1+($A$10-$A$1)/9 and copy down. Then format as date.
--
Gary''s Student - gsnu200838


"OHNESORGE" wrote:

I have a start date in Cell A1-Dec 1, 2008
I have a complteion date in cell A10-Dec 30,2008
I need the cells A2-A9 to reflect the dates spread out evenly amongst them.