Changes

Jump to navigation Jump to search
Line 4: Line 4:     
==Description==
 
==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==
 
==Examples==
writer
2,661

edits

Navigation menu