Convert number to month name?

Question

I have this formula:

DQ11=DATE("20"&LEFT(DN18;2);1;-2)-WEEKDAY(DATE("20"&LEFT(DN18;2);1;3))+RIGHT(DN18;2)*7

which gives the number 41519.

For reference:

DN18 = 1336

Now I want to convert 41519 to a month name. How do I do that? I've tried:

=TEXT(DQ11;"mmm")

but it returns 00.

Answer 1

Apparantly Text(DQ11;"MMM") gives me what I want.

I don't know why mmm didn't work and hope that my code will work on other vesions of Excel.