Difference between revisions of "Manuals/calci/MONTH"
Jump to navigation
Jump to search
| (One intermediate revision by one other user 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== | ==ZOS== | ||
| − | *The syntax is to find the month of the given serial number in ZOS is <math>MONTH( | + | *The syntax is to find the month of the given serial number in ZOS is <math>MONTH(Value)</math>. |
| − | **<math> | + | **<math>Value</math> is the serial number of the month. |
*For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014") | *For e.g.,MONTH(54178),MONTH(4000),MONTH("10/4/2014") | ||
| Line 30: | Line 31: | ||
==References== | ==References== | ||
*[https://exceljet.net/excel-functions/excel-month-function Month] | *[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 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).
, 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 inZOS
- 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