Tom/Bob

Thanks for your insights. I like the idea of testing if the cell is
numeric before comparing it to the date. That aught to work a treat.

However your assumption that problem #2 was probably on an xl97 machine
was incorrect (apologies for not specifying that in my original query).
It was actually on an xl 2000 sr-1 machine whilst I am on xl 2000
sp-3. Unless someone advises me otherwise I would have thought that
the service packs would make no difference. So either (a) the service
packs do make a difference and could cause this sort of error or (b)
they don't make a difference and the error is caused by some other
unknown factor. I'd prefer it to be the former as that's easiest to
solve.

Let me know if you have anything you can add to this, as you can tell
I'm pretty much stumped!!!

Kind regards

Stuart