#div/0!

[Jo Freeman]

Hi All



I have a spreadsheet that calculates an average per week per item. Column A has a "From Date", Column B is the "To Date", Column C is the income and Column D has a formula to calculate the average per week. When there are no dates in a particular row, the above appears. I don't want to delete the formula as there will be data entered. Can I stop #DIV/0! from appearing and just show an empty cell?

Many thanks.