hi ,

you should putting real date in cell B1:M1 (1900-01-01, 1900-02-01...)
and then put those twelve cells in the format "mmm"

--
isabelle



Le 2012-02-07 14:36, thermalman a écrit :
Hello Isobelle, I have added your formula to worksheet 2, Cell B2 only
but it is giving me an error. Can you have a look at the worksheet
attached and let me know where I am going wrong.


Many Thanks
Thermalman


+-------------------------------------------------------------------+
|Filename: FunctionExample.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=290|
+-------------------------------------------------------------------+