Manuals/calci/test
Jump to navigation
Jump to search
Syntax
Examples
''''''' ''''
Description
DATEVALUE
Let's see an example in C1R1(Column2,Row1)
=datevalue(C1R1)
DATEVALUE returns serial number of textdate in C1R1
is (1201672800000).
Consider an another example
=datevalue("30 jan")
It return the serial number of text date(30 jan) is(1201672800000).
Calci returns the serial number of the text date.
If the year portion of date_text is omitted, DATEVALUE uses the current year .Time information in date_text is ignored(see in e.g2).
Remarks
=DATEVALUE(textdate)
where,
textdate - represents the date.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1/30/2008 | 1201672800000 | ||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
