http://wiki.zcubes.com/index.php?action=history&feed=atom&title=Manuals%2Fcalci%2Fdate1 2026-06-16T11:36:04Z Revision history for this page on the wiki MediaWiki 1.35.2 http://wiki.zcubes.com/index.php?title=Manuals/calci/date1&diff=344&oldid=prev 2013-10-25T02:32:46Z

<p>Created page with &quot;&lt;div id=&quot;6SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt; &#039;&#039;&#039;DATE&#039;&#039;&#039;(SomeYr,SomeMn,SomeDt) where, &#039;&#039;&#039;SomeYr&#039;&#039;&#039; - represents year can be 1 to 4 digits. &#039;&#039;&#039;SomeMn&#039;&#039;&#039;-re...&quot;</p> <p><b>New page</b></p><div>&lt;div id=&quot;6SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> '''DATE'''(SomeYr,SomeMn,SomeDt)<br /> <br /> where,<br /> <br /> '''SomeYr''' - represents year can be 1 to 4 digits.<br /> <br /> '''SomeMn'''-represents month from 1 to 12.<br /> <br /> '''SomeDt''' -represents date from 1 to 31.<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;1SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> This function returns the serial numbers that represents a specific format.By default, the result is formatted as a date.<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;12SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;left&quot;&gt;TDATE&lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;8SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> Lets see an example in (Column2,Row1)<br /> <br /> &lt;nowiki&gt;=SUM(B3:B4)&lt;/nowiki&gt;<br /> <br /> SUM of B3 and B4 (-5).<br /> <br /> Consider another example<br /> <br /> &lt;nowiki&gt;=SUM(&quot;3&quot;,4,TRUE)&lt;/nowiki&gt;<br /> <br /> SUM of 3, 4 and TRUE is (8).<br /> <br /> Let see an in example in (C2R3)<br /> <br /> =SUM(B2:B6)<br /> <br /> Calci adds only numbers (12).<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;10SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Syntax &lt;/div&gt;&lt;div class=&quot;ZEditBox&quot;&gt;&lt;center&gt;&lt;/center&gt;&lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;3SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Examples &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;11SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Description &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;2SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> {| id=&quot;TABLE3&quot; class=&quot;SpreadSheet blue&quot;<br /> |- class=&quot;even&quot;<br /> | class=&quot; &quot; |<br /> | Column1<br /> | Column2<br /> | Column3<br /> | Column4<br /> |- class=&quot;odd&quot;<br /> | class=&quot; &quot; | Row1<br /> | class=&quot;sshl_f&quot; | SMITH<br /> | 3<br /> | 4<br /> | class=&quot;sshl_f&quot; | 5<br /> |- class=&quot;even&quot;<br /> | class=&quot; &quot; | Row2<br /> | class=&quot; &quot; | 7<br /> | class=&quot;sshl_f&quot; | 8<br /> | 9<br /> | class=&quot;sshl_f&quot; | 128<br /> |- class=&quot;odd&quot;<br /> | Row3<br /> | class=&quot; &quot; | 12<br /> | class=&quot;sshl_f&quot; | 67968<br /> | 14<br /> | class=&quot;sshl_f &quot; | 15<br /> |- class=&quot;even&quot;<br /> | Row4<br /> | 17<br /> | class=&quot; &quot; | 18<br /> | class=&quot;sshl_f&quot; | 10000<br /> | class=&quot; &quot; | 20<br /> |- class=&quot;odd&quot;<br /> | class=&quot; &quot; | Row5<br /> | 36<br /> | 67994<br /> | 10027<br /> | 168<br /> |- class=&quot;even&quot;<br /> | Row6<br /> | 6<br /> | 0.8509<br /> | 1.6198<br /> | 0.5253<br /> |}<br /> <br /> &lt;div align=&quot;left&quot;&gt;[[Image:calci1.gif]]&lt;/div&gt;&lt;/div&gt;<br /> ----</div>

MassBot1