[libreoffice-users] Calc =MONTH problem

Hello

Not sure if I'm doing something wrong, if theres a setting I haven't set or
I've found a bug

Libreoffice Calc
Program settings are >>Options>>Language Settings>>Languages
User interface 'English (uk)'
Date acceptance patterns 'D/M/Y;D/M;D-M'

And the problem is
In a cell (CF3) I have the date >> 01/09/2013 which is DD/MM/YYYY
In another cell I have =MONTH(CF3) this cell is formatted as 'date' 'MMM'
and I expect the cell to show 'Sep' it actually shows 'Jan'
So its showing the day as the month and not the month as the month

Any ideas how to fix 



-----
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context: http://nabble.documentfoundation.org/Calc-MONTH-problem-tp4070686.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted