Excel offers many great date functions to manipulate date fields and create new date fields to your specifics. However there isn’t one simple function to display the name of the current month. We still can get this, it just takes a few nested functions.
Let’s start off by pulling in today’s date. We just use this formula =Today()
Now that we have the current date, Excel gives us the function Month which will give us the month of any formula or date.
So we will use =Month(today()) . This will give us a number of the current month. for example, if it is January, the result is a 1.
The problem with the above is the field is formatted as Date. We need to change it to general, so it will just show the number of the month. Just right click on the cell and go to Format Cell and pick General.
We now have the number 1 as the result since the current month is January.
But we want it to say “January” instead of the number 1. We can do this with the CHOOSE function.
Remember, the CHOOSE function let’s you give a number and choices and then it will pull the choice based on the number.
Since we have the formula as a 1, we want to list the 12 months as our choices. Then this number will pick it for you.
This function chooses among the 12 choices. The first part of the argument is the number of the choice. Since we saw it is a 1, then it takes the first result, “January”. If it was a 2, it would pick the 2nd choice, “February”.
So this is one way to get the full name of the current month. Hope this helps!
For more information on Excel functions, check out our new product “Master Excel Functions” at http://www.excelbyjoe.com/excelfunctions
Or check out the video to explain this: