Topic: office

Displaying the Month

8 Mar 04

If you need to return the month component from a date, you have two choices. You can use the Month() function in the form

Month(date)

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.

See Other tips, Legacy Tips