Here's our Microsoft Office Tip for.. November 15, 2005
Click Here to see a complete list of all of our previously released Tips!
Displaying the Month
If you need to return the month component from a date, you have two choices. You can use the Month() function in the form


which will return a month's integer value. For instance, if date is April 21, 2000, the Month() function will return the value 4.

If you need to see the month's name, you can use a custom format. Simply select the cell that contains your date, and then choose Format, Cells. Next, choose Custom and enter the format code mmmm. When you return to the worksheet, Excel will display just the month's name.