writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − Syntax+ + + + + − </div></div> − ---- − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify"> − + + + + + − </div></div>+ − ----+ − <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>+ − ----+ − <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> − <font size="5">Description</font>+ − − </div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6" face="Arial, sans-serif"><font size="6">'''MONTH '''</font></font> − − '''<font size="6" face="Arial"></font>''' − − </div></div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''MONTH'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''sn)'''</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">where sn </font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">is the date of the month .</font></font></font> − − </div></div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives the month of a date represented by a serial number. </font></font></font> − − </div></div> − ---- − <div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example in Column1Row1</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">C1R1 = 26-Jan-1950</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e. =MONTH(C1R1) is 1</font></font></font> − − </div></div> − ---- − <div id="5SpaceContent" class="zcontent" align="left"> − − {| id="TABLE6" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class=" " | 26-JAN-1950 − | class="sshl_f" | 1 − | class=" " | − | class=" " | − |- class="even" − | class=" " | Row2 − | class=" " | − | class="f52543 " | − | class=" SelectTD" | − <div id="5Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="5Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class=" " | − |- class="odd" − | Row3 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<div style="font-size:30px">'''MONTH(sl.no)'''</div><br/>
*<math>sl.no </math> is the serial number of the month.
==Description==
*This function gives the month of a given date represented by a serial number.
*In <math>MONTH(sl.no), sl.no</math>, 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)
Examples
==Examples==
#MONTH(32786)=10
#MONTH(74562)=2
#MONTH("9/1/1999")=9
#MONTH("20-may-2004")=5
==See Also==
*[[Manuals/calci/DAY | DAY ]]
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/YEAR | YEAR ]]
==References==