Difference between revisions of "Manuals/calci/test"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
(No difference)
|
Revision as of 20:32, 24 October 2013
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 |
