Hi Ron,
Your suggestion is a good point as in NZ we use dd/mm/yy for date format and
the computers I think have a default on purchasing of US dates so it may well
be the answer that they may not have changed the setting to NZ.
Thanks for the help. Can't get it checked now until Monday afternoon as it
is now the weekend. Will let both you and Roger know how I go.
Thanks heaps
Sue

"Ron Rosenfeld" wrote:

On Fri, 11 Nov 2005 12:39:52 +0000, Roger Govier
wrote:

Hi Sue

In addition to Ron's suggestions, I was also thinking about Text entries.
Are the dates in I2 true dates, or text values looking like dates?
A simple test in a blank cell of =I2+1 would resolve this, and I guess could
be carried out over the phone rather than a visit - if it's not too late!!

Regards

Roger Govier

Did you try that?

On my system (Excel 2002), text entries that are otherwise legal dates will get
handled correctly by Sue's formulas.


--ron