Manuals/calci/AGINGINDAYS

AGINGINDAYS (Day,From)

• $Day$ is any date.
• $From$ is also any date value.

Description

• This function displays the value of Aging in days.
• In $AGINGINDAYS(Day,From)$ ,$Day$ is any date value.From value is also any date value which is to subtracted from the given date.
• This formula subtracts the first date value from the original second date.
• This calculates number of days in between the given dates.
• DD/MM/YYYY format can also be used. For Example:"14/5/2005[DD/MM/YYYY]".
• Range values also can be used. For Example: AGINGINDAYS("12/10/2030",#6/12/2017-8/13/2017)
• #date notation needs mm/dd/yy format.

Examples

1. AGINGINDAYS("12/10/2030","6/12/2017") = 4929
2. AGINGINDAYS("6/19/2003","1/7/2009") = -2029
3. AGINGINDAYS("2/29/2020","3/1/2020") = -1

Related Videos

Aging in days

See Also

• DATEVALUE
• DAYS360

References

DATE

• List of Main Z Functions

• Z3 home