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.
• Here date value displaying as a number.
• So here displaying the date value from 1 to 31 from the given date.
• 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: 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