Definition of MONTH
Returns the month of the year a specific date falls in, in numeric format.
MONTH(DATE(1969, 7, 20))
date- The date from which to extract the month. Must be a reference to a cell containing a date, a function returning a date type, or a number.
- Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as
TO_DATE, or a date serial number of the type returned by the
MONTHdoes not autoconvert number formats. Therefore,
MONTH(10/10/2000)is interpreted as
MONTH(0.005), the quotient of 10 divided by 10 divided by 2000.
MONTHreturns the intuitive understanding of the month of the year, and is useful primarily in other calculations rather than to extract the month from a known date, as that value is easily known from a plain reading of the entire date.
YEAR: Returns the year specified by a given date.
WEEKDAY: Returns a number representing the day of the week of the date provided.
TO_DATE: Converts a provided number to a date.
N: Returns the argument provided as a number.
DAY: Returns the day of the month that a specific date falls on, in numeric format.
DATEVALUE: Converts a provided date string in a known format to a date value.
DATE: Converts a provided year, month, and day into a date.
In order to use the MONTH formula, start with your edited Excellentable
Then type in the MONTH Formula in the area you would like to display the outcome:
By adding the values you would like to calculate, Excellentable generates the outcome: