# MONTH

Formulas / MONTH
Retrieve the month from a date.
`MONTH(serial_number)`
• serial_number - required, the date of the month to find

## Examples

• `=MONTH("23-Aug-2012")`

The MONTH function returns the month number of a given date. For example, this returns 8 because August is 8 in a year.

• `=MONTH("11-May-2019")`

The MONTH function can take a date in any format and will still return the month number associated with the date. For example, this returns 5 because May is 5 in a year.

• `=MONTH(A1)`

The MONTH function can also be used with a cell reference that contains a date. For example, if cell A1 contains the date "19-Feb-2016", the formula returns 2 because February is 2 in a year.

• `=MONTH(43183)`

The MONTH function can also take a serial number as an argument. For example, this returns 11 because November is 11 in a year. The serial number 43183 corresponds to the date 11-Nov-2019.

• `=MONTH(DATE(2019, 5, 11))`

The MONTH function can also be combined with the DATE function to return the month number of a date created from year, month, and day arguments. For example, this returns 5 because May is 5 in a year.

## Summary

The MONTH function is used to extract the month of a date in the form of an integer (1 to 12). It can be used with either a serial number or a date provided by the DATE function or other formulas/functions.

• The MONTH function takes a valid date in Sourcetable as its argument and returns a number between 1 and 12.
• The MONTH function resets every 12 months, meaning it returns 1 at the beginning of each year.

What is the MONTH function?
The MONTH function is a function in Sourcetable that returns the month of a date as a number. It takes a serial number as its argument, which represents a date.
What dates can the MONTH function return?
The MONTH function can return dates entered with the DATE function, as well as dates entered as text.
How do I use the MONTH function?
The MONTH function is used in Sourcetable to return the month of a date as a number. To use the MONTH function, enter the function in a cell and enter the serial number that represents the date in the parentheses. The serial number can be a date entered with the DATE function, or a date entered as text.

## Make Better Decisions With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.

Drop CSV