On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Thursday, May 22, 2014

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)

Popular Posts