Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Manuals/calci/DATEVALUE (view source)
Revision as of 07:19, 14 November 2013
, 07:19, 14 November 2013Created page with "<div style="font-size:30px">'''DATEVALUE(textdate)'''</div><br/> *where text date represents a date in CALCI format ==Description== *This function gives the serial number of..."
<div style="font-size:30px">'''DATEVALUE(textdate)'''</div><br/>
*where text date represents a date in CALCI format
==Description==
*This function gives the serial number of the given textdate.
*This is used to convert the a date in to a specified serial number.
*By default , the serial number is starting from 1/1/1900 .
*i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918(calci) 17394(Excel).
*This function will give the result as Error when the textdate is below range of 1/1/1900.
*Also if the year value is not entered in the textdate ,this function will consider the current year.
*Time information in textdate is ignored.
==Examples==
*DATEVALUE("3/20/2005")=38431
*DATEVALUE("6/7/1960")=58599(CALCI)=22074(EXCEL)
*DATEVALUE("1-APR-1976")=27851
*DATEVALUE("12/12")=37237(CALCI)41620(EXCEL) for the current year 2013.
==See Also==
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/DAY | DAY]]
==References==
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
*where text date represents a date in CALCI format
==Description==
*This function gives the serial number of the given textdate.
*This is used to convert the a date in to a specified serial number.
*By default , the serial number is starting from 1/1/1900 .
*i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918(calci) 17394(Excel).
*This function will give the result as Error when the textdate is below range of 1/1/1900.
*Also if the year value is not entered in the textdate ,this function will consider the current year.
*Time information in textdate is ignored.
==Examples==
*DATEVALUE("3/20/2005")=38431
*DATEVALUE("6/7/1960")=58599(CALCI)=22074(EXCEL)
*DATEVALUE("1-APR-1976")=27851
*DATEVALUE("12/12")=37237(CALCI)41620(EXCEL) for the current year 2013.
==See Also==
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/DAY | DAY]]
==References==
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]