Manuals/calci/DAYINDEX

DAYINDEX (Value)

• $Value$ is any date value.

Description

• This function shows the date value as a number.
• In $DAYINDEX(Value)$,$Value$ 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

• DATEVALUE
• DAYS360

References

DATE

• List of Main Z Functions

• Z3 home