How is it 'not possible" ? What happens with =F1-D1 when both cells are
merged with empty neighbours
I was able to do it - I did have to format the cell with the formula to
General
It even worked when the formula was in a merged cell
I use XL2003; what version do you have?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"labatyd" wrote in message
...
Have the date in the format of Month xx, 2006 in a set of six merged
cells.
In another set of six merged cells I have a later date.

Is in not possible to extract the difference in days into a third set of
merged cells. Works fine and displays nicely if the dates are in single
wide cells but doesn't seem to work from merged cells. :-(

Eventually the sheet will contain about 50 counter readings which are
taken 30 to 60 days apart. We need to have it calculate the interval in
days and the number of operations per day for each piece of equipment.

(I've used narrow column widths since lower down would be boxes where a
single digit or check mark can be placed to indicate levels or good or
poor status condition).

Is there a better way to layout out the spread sheet.

TIA