MONTH Function (Functions in Excel)
Original Date | Month | |
1-Jan-98 | 1 | =MONTH(C4) |
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. |
Please enter your date of birth in the format dd/mm/yy | 3/25/1962 | |
You were born in | January | =MONTH(F20) |
0 comments:
Post a Comment