Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (11 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''MONTH(Value)'''</div><br/> |
| + | *<math>Value</math> is the serial number of the month. | ||
| + | **MONTH(), converts a serial number to a month. | ||
| − | + | ==Description== | |
| + | *This function gives the month of a given date represented by a serial number. | ||
| + | *In <math>MONTH(Value)</math>, <math>Value</math> is the serial number of the month or we can give the date value in[[Manuals/calci/DATE | 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 <math>MONTH(Value)</math>. | |
| − | < | + | **<math>Value</math> is the serial number of the month. |
| + | *For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014") | ||
| − | Examples | + | ==Examples== |
| + | #=MONTH(32786) = 10 | ||
| + | #=MONTH(74562) = 2 | ||
| + | #=MONTH("9/1/1999") = 9 | ||
| + | #=MONTH("20-may-2004") = 5 | ||
| − | + | ==Related Videos== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {{#ev:youtube|HveRi5_lSMU|280|center|MONTH}} | |
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/DAY | DAY ]] | |
| − | + | *[[Manuals/calci/DATE | DATE ]] | |
| + | *[[Manuals/calci/YEAR | YEAR ]] | ||
| − | + | ==References== | |
| + | *[https://exceljet.net/excel-functions/excel-month-function Month] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 13:33, 9 July 2018
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.
- MONTH(), converts a serial number to a 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 Value} 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
Related Videos
See Also
References