Manuals/calci/AGINGINDAYS

AGINGINDAYS (Day,From)

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

Description

• This function shows 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 be get subtracted from the given date.
• So this formula subtracts the first date value from the original second date.
• This calculates number of days in between those given dates.
• 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: 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