A bit late to the party, but this also works if you have the week number. For example, if you have week number 23, you can determine the month with the following modification to the formula: =TEXT(A1*7,mmm). Follow the same logic presented in the above table, just swap the numbers as needed.
Directive (programming) In computer programming, a directive pragma (from pragmatic) is a language construct that specifies how a compiler (or other translator) should process its input. Directives are not part of the grammar of a programming language, and may vary from compiler to compiler.
Sure this is possible. The #define is processed by the preprocessor before the compiler does anything. It is a simple text replacement. The preprocessor doesn't even know if the line of code is inside or outside a function, class or whatever. By the way, it is generally considered bad style to define preprocessor macros in C++.