Manuals/calci/DAYINDEX

DAYINDEX (Value)


  • is any date value.

Description

  • This function shows the date value as a number.
  • In  ,  is any date value.
  • 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]".
  • Range values can also be used. For Example: DAYINDEX(#9/27/2000-11/25/2000).
  • #date notation needs mm/dd/yy format .

Examples

  1. DAYINDEX("9/27/2000") = 27
  2. DAYINDEX("2/4/1976") = 4
  3. DAYINDEX("19/7/2017[DD/MM/YYYY]") = 19

Related Videos

Day Index

See Also

References

DATE