Answer: =MONTH(F5)
Explanation:
The MONTH function in Excel returns the month, a number from 1 (January) to 12 (December).
It’s syntax is;
“=MONTH(serial_number)”
Where serial number refers to the date in question, which could either be a date itself or a cell reference.
The MONTH function is used to extract the month number from a date.
If cell F5 contains “July 8, 2016”, the formula “=MONTH(F5)” inputed in another cell will give the value “7”.
This is because the month July is the 7th month of the year.
