Home Computer Learn How to Use Month Excel Formula

Learn How to Use Month Excel Formula

43 second read
0
0
59
1ST 2

MONTH

Month Excel formula

 

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.
Month Excel Formula Example
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

What is Account Master & How to Create Modify and Delete

What is Account Master & How to Create Modify and Delete Administration > Masters &…