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 takes two forms: defining a constant and creating a macro. When defining a constant, you may optionally elect not to provide a value for that constant.In this case, the token will be replaced with blank text, but will be defined for the purposes of #ifdef and ifndef.f a value is provided, the given token will be replaced literally with the remainder of the text on the line. You should be careful when using #define in this way; see this article on the c preprocessor for a list of gotchas.