| 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== |