Gary's Student part 2 or Question 2 on excel spreading Dates evenl
 

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 part 2 or Question 2 on excel spreading Dates evenl
 

in Cell D4:
=if(C3='', '', d3-d2)
Note: the '' is two single quotes.

Cheers.
--Dan

"ohnesorge" wrote:

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 part 2 or Question 2 on excel spreading Dates evenl
 

With the same example (A1 thru A10), in A2 enter:

=IF(OR($A$1="",$A$10=""),"",A1+($A$10-$A$1)/9) and copy down

So if either A1 or A10 is blank, the values in between will also be blank.
--
Gary''s Student - gsnu200838


"ohnesorge" wrote:

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 part 2 or Question 2 on excel spreading Dates e
 

I might not have explained correctly, sry for that If A1=12/10/08, and i
input a compltetion date B1=12/11/08= my answer in C1= (1) which is correct.
My Question is that how do i make C1 display ZERO instead of 39796. if i do
not enter a number into B1, C1 comes up 39,796 which is a problem when i am
trying to add the total amount of days we are behind or on schedule.

"Gary''s Student" wrote:

With the same example (A1 thru A10), in A2 enter:

=IF(OR($A$1="",$A$10=""),"",A1+($A$10-$A$1)/9) and copy down

So if either A1 or A10 is blank, the values in between will also be blank.
--
Gary''s Student - gsnu200838


"ohnesorge" wrote:

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