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.
The #define directive causes the compiler to substitute token-string for each occurrence of identifier in the source file. The identifier is replaced only when it forms a token.f the name of the macro being defined occurs in token-string (even as a result of another macro expansion), it is not expanded. A second #define for a macro with the same name generates a warning unless the second token sequence is identical to the first.