Excel Spreading dates evenly in a row of cells

O

OHNESORGE

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

ohnesorge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top