View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OHNESORGE OHNESORGE is offline
external usenet poster
 
Posts: 12
Default 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