Difference between revisions of "Manuals/calci/AGINGINDAYS"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
*So this formula subtracts the first date value from the original second date. | *So this formula subtracts the first date value from the original second date. | ||
*This calculates number of days in between those given dates. | *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) | *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 . | * #date notation needs mm/dd/yy format . | ||
Revision as of 13:12, 22 May 2018
AGINGINDAYS (Day,From)
- is any date.
- is also any date value.
is any date.
is also any date value.Description
- This function shows the value of Aging in days.
- In , 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
- AGINGINDAYS("12/10/2030","6/12/2017") = 4929
- AGINGINDAYS("6/19/2003","1/7/2009") = -2029
- AGINGINDAYS("2/29/2020","3/1/2020") = -1
See Also
References