View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ma2Weir Ma2Weir is offline
external usenet poster
 
Posts: 4
Default Date Calculations before date entered

I am creating a chart, that adds a varying number of days as you go across
the chart. I have entered formulas to add, and it works fine. EXCEPT...when
there is no starting date entered, all boxes are filled with data. I know it
adds from 01/01/00, but really don't want to see all these nonsensical dates.
I want a clean sheet that data shows up when I enter the baseline cell data.
Any suggestions?