On Sun, 23 Mar 2008 05:09:00 -0700, Nils Titley
wrote:

Ron,

Okay, but will setting the international xlDateOrder help? And how do I do
that in my Macro.

As I wrote before, you need to determine what your input is and insure that

RunDate(MyNum) is returning the proper date.

Excel can usually convert between one date format and another, but you need to
be certain that your RunDate function is returning an unambiguous date.
--ron