MONTH Function in MS-Excel

	C	D
3	Original Date	Month
4	1-Jan-98	1	=MONTH(C4)
5	1-Jan-98	January	=MONTH(C5)

What Does It Do?

This function extracts the month from a complete date.

Syntax

=MONTH(Date)

Formatting

Normally the result will be a number, but this can be formatted to show the actual month by using Format,Cells,Number,Custom and using the code mmm or mmmm.

Example

The =MONTH function has been used to calculate the name of the month for your birthday.

					F
20	Please enter your date of birth in the format dd/mm/yy				3/25/1962
21	You were born in				January	=MONTH(F20)