Note: I have fixed the issue by leaving the dates in text format all the
way through.

Still interested in the root cause though if anyone can advise...

Cheers :)


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=566546