View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Date Calculations before date entered

Surround your calculations in an If statement, as in

=if(a1="","",.....)

--
Regards,
Fred


"Ma2Weir" wrote in message
...
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?