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.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV