Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Spreading dates evenly in a row of cells | Excel Discussion (Misc queries) | |||
Map Network Drive FAO Gary's Student | Excel Discussion (Misc queries) | |||
To Gary's Student | Excel Discussion (Misc queries) | |||
To: Gary's Student cell address reply | Excel Discussion (Misc queries) | |||
Is Gary's Student here | Excel Discussion (Misc queries) |