Manuals/calci/date1

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