Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing large number of non contiguous cells evenly distributed | Excel Worksheet Functions | |||
Spreading 1 large number evenly into several cells | Excel Worksheet Functions | |||
i have to add cells evenly spaced, eg a1 + a11+a21+...+a991 | Excel Worksheet Functions | |||
How do you distrubute columns evenly in Excel 2000? | Excel Discussion (Misc queries) | |||
Variable dates on X axis evenly spaced (should not be) | Charts and Charting in Excel |