Difference between revisions of "Manuals/calci/date1"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''DATE'''(SomeYr,SomeMn,SomeDt) where, '''SomeYr''' - represents year can be 1 to 4 digits. '''SomeMn'''-re...") |
(No difference)
|
Latest revision as of 20:32, 24 October 2013
DATE(SomeYr,SomeMn,SomeDt)
where,
SomeYr - represents year can be 1 to 4 digits.
SomeMn-represents month from 1 to 12.
SomeDt -represents date from 1 to 31.
This function returns the serial numbers that represents a specific format.By default, the result is formatted as a date.
TDATE
Lets see an example in (Column2,Row1)
=SUM(B3:B4)
SUM of B3 and B4 (-5).
Consider another example
=SUM("3",4,TRUE)
SUM of 3, 4 and TRUE is (8).
Let see an in example in (C2R3)
=SUM(B2:B6)
Calci adds only numbers (12).
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | SMITH | 3 | 4 | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 67968 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 36 | 67994 | 10027 | 168 |
| Row6 | 6 | 0.8509 | 1.6198 | 0.5253 |
