MONTH
Gives the month only of the given date
Syntax of Excel Month formula:
=MONTH(serial_number)
In words:
=Just give the month from(this date)
Examples of Excel Month Formula
=MONTH(“8/6/1986”) will result in 8. Remember the date is written in month/day/year format.