hi Why Tea

Using the month name is not possible
If you use a ISO date string it is working in all excel versions

=MONTH("2006-10-01")

More info about the ISO standard you can find here
http://www.rondebruin.nl/isodate.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Why Tea" wrote in message ps.com...
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