Ron de Bruin wrote:
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

Thanks Ron. Very informative Website too.

I need to use month name as the worksheet is meant for a monthly
report. Writing "2006-10-01" is not really the same as "Oct 2006". This
is especially the case when you are dealing with ISO weeks, as the
months don't always begin at the 1st.