Manuals/calci/MONTH

Revision as of 20:22, 19 June 2015 by Swapna (talk | contribs)
MONTH(value)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle value} is the serial number of the month.

Description

  • This function gives the month of a given date represented by a serial number.
  • In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MONTH(value)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sl.no} is the serial number of the month or we can give the date value in DATE function format.
  • MONTH("2/1/1997") for 2nd month.
  • The result of the function is an integer 1 to 12(January to December).

ZOS

  • The syntax is to find the month of the given serial number in ZOS is Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle MONTH(value)} .
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle value} is the serial number of the month.
  • For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014")

Examples

  1. =MONTH(32786) = 10
  2. =MONTH(74562) = 2
  3. =MONTH("9/1/1999") = 9
  4. =MONTH("20-may-2004") = 5

Related Videos

MONTH

See Also

References