Difference between revisions of "Manuals/calci/AGINGINDAYS"

Latest revision as of 06:38, 15 February 2019

AGINGINDAYS (Day,From)

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.

@@ Line 4: / Line 4: @@
 ==Description==
-*This function shows the value of  Aging in days.
+*This function displays the value of  Aging in days.
-*In <math>AGINGINDAYS(Day,From)</math> ,<math>Day</math>  is any date value.From value is also any date value which is to be get subtracted from the given date.
+*In <math>AGINGINDAYS(Day,From)</math> ,<math>Day</math>  is any date value.From value is also any date value which is to subtracted from the given date.
-*So this  formula subtracts the first date value from the original second  date.
+*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 the given dates.
-*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
+*DD/MM/YYYY format can also be used. 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)
+*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 .
+* #date notation needs  mm/dd/yy format.
 ==Examples==