Hi

I would like to bring out the month from a given date in the format 'mmm-yy'. The original date is in dd/mm/yyyy format.

But when I am using the Month function with format "mmm-yy", it is giving an erratic result.

Say for example,


A2 B2

15/04/2015 =MONTH(A2) Result = Jan-00


Why is this happening?

regards

San