Difference between revisions of "Manuals/calci/AGINGINDAYS"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''AGINGINDAYS (Day,From)'''</div><br/> *<math>Day</math> is any date. *<math>From</math> is also any date value. ==Description== *This function s...") |
|||
| 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 Range values also. For Example: AGINGINDAYS("12/10/2030",#6/12/2017-8/13/2017) | ||
| + | * #date notation needs mm/dd/yy format . | ||
==Examples== | ==Examples== | ||
Revision as of 13:55, 15 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 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