MONTH Formula in Excel

 

What Does It Do?

This function extracts the month from a complete date.

image

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.

No comments:

Post a Comment