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)
- 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 , 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 .
- 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