writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 11:
Line 11: + Line 25:
Line 26: +
no edit summary
*If the year value is not entered in the <math>String</math>, this function will consider the current year.
*If the year value is not entered in the <math>String</math>, this function will consider the current year.
*Time information in <math>String</math> is ignored.
*Time information in <math>String</math> is ignored.
*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
*We can use Range values also. For Example: DATEVALUE(#3/20/2005-5/23/2006).
*We can use Range values also. For Example: DATEVALUE(#3/20/2005-5/23/2006).
* #date notation needs mm/dd/yy format .
* #date notation needs mm/dd/yy format .
*=DATEVALUE("1-APR-1976")=27851
*=DATEVALUE("1-APR-1976")=27851
*=DATEVALUE("12/12")=37237 for the current year 2013.
*=DATEVALUE("12/12")=37237 for the current year 2013.
*=DATEVALUE("23/4/2015[DD/MM/YYYY]") = 42117