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?
|