Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''MONTH( | + | <div style="font-size:30px">'''MONTH(Value)'''</div><br/> |
| − | *<math> | + | *<math>Value</math> is the serial number of the month. |
| + | **MONTH(), converts a serial number to a month. | ||
==Description== | ==Description== | ||
*This function gives the month of a given date represented by a serial number. | *This function gives the month of a given date represented by a serial number. | ||
| − | *In <math>MONTH( | + | *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. | *MONTH("2/1/1997") for 2nd month. | ||
| − | *The result of the function is an integer 1 to 12(January to December) | + | *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(32786) = 10 |
| − | #MONTH(74562)=2 | + | #=MONTH(74562) = 2 |
| − | #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== | ||
| Line 21: | Line 30: | ||
==References== | ==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)
- is the serial number of the month.
- MONTH(), converts a serial number to a month.
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 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