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.


Frequently Asked Questions

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.

Related Functions

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.