| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating age of debt (30,60,90 days)
Can anyone show me the logic for calculating the 30, 60,90,120 ages of
items in an account. The calculations are complicated by the fact that there might be new invoices and down payments in the period under question eg: Date/description/amount/balance 1 May /Invoice/$1000/$1000 15 June/Payment/$250/$750 28 June/Invoice/$500/$1250 Thanks Laurence |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating age of debt (30,60,90 days)
On 04/09/2012 11:44 AM, Laurence Lombard wrote:
Can anyone show me the logic for calculating the 30, 60,90,120 ages of items in an account. The calculations are complicated by the fact that there might be new invoices and down payments in the period under question eg: Date/description/amount/balance 1 May /Invoice/$1000/$1000 15 June/Payment/$250/$750 28 June/Invoice/$500/$1250 Thanks Laurence I managed to figure out something. I have tackled the problem with VBA code. It would be interesting to know whether one can do it with formulas. Here is my take on the subject https://dl.dropbox.com/u/11809449/DebtAgeAnalysis.xls -- Regards Laurence |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Need to know percapita consumer debt. Debt amount is 2121.1 bill. | Excel Discussion (Misc queries) | |||
| Calculating credit card debt, interest , and payments | Excel Worksheet Functions | |||
| Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming | |||
Linear Mode
