Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
#=MONTH("9/1/1999") = 9 | #=MONTH("9/1/1999") = 9 | ||
#=MONTH("20-may-2004") = 5 | #=MONTH("20-may-2004") = 5 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|HveRi5_lSMU|280|center|MONTH}} | ||
==See Also== | ==See Also== | ||
Revision as of 19:22, 19 June 2015
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 (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 value} is the serial number of the month.
- For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014")
Examples
- =MONTH(32786) = 10
- =MONTH(74562) = 2
- =MONTH("9/1/1999") = 9
- =MONTH("20-may-2004") = 5