writer
2,661
edits
Changes
Manuals/calci/DAYINDEX (view source)
Revision as of 11:50, 15 February 2019
, 11:50, 15 February 2019→Description
*This function shows the date value as a number.
*This function shows the date value as a number.
*In <math>DAYINDEX(Value)</math>,<math>Value</math> is any date value.
*In <math>DAYINDEX(Value)</math>,<math>Value</math> is any date value.
*Here date value displaying as a number.
*The function displays the date value in the range of 1 to 31, from the given date.
*DD/MM/YYYY format can also be used. For Example:"14/5/2005[DD/MM/YYYY]".
*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
*Range values can also be used. For Example: DAYINDEX(#9/27/2000-11/25/2000).
*We can use Range values also. For Example: DAYINDEX(#9/27/2000-11/25/2000).
* #date notation needs mm/dd/yy format .
* #date notation needs mm/dd/yy format .