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