Ron,
thanks for the very long and informative post :)
i think that you are right and some of the fields in the "RawData" are
text fields and not true date fields. i didnt notice it before as it
all appears correct to the naked eye.
my mistake.
so if all the date fields are actually serial numbers "38553" and this
doesnt change, only the way the are represented on screen.
Therefore any calculations will look at the serial in the "Rawdata" and
compare it the another serial.
so whether the dates are in US or UK format will not matter.
--
jarvo
------------------------------------------------------------------------
jarvo's Profile:
http://www.excelforum.com/member.php...o&userid=18983
View this thread:
http://www.excelforum.com/showthread...hreadid=395748