The Month() function works for Month("Oct 2006") - gives a value of 10;
but it doesn't work if you happen to be in Sweden, you will need to use
Month("Okt 2006"). How do you overcome the problem with VBA? I would
like the locale of the worksheet to be any one of the English speaking
countries.

/Why Tea