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

File:Calci1.gif

---