Spreadsheets and AAoA

[Anonymous]

After reading a post earlier this morning someone mentioned using a spreadsheet to determine AAoA. Anyone have a link to help me to set one set up? A while back I had set mine up to determine amounts to pay off in a certain amount of time but didn't know it would calculate age of accounts.

[FocusOnFICO]

There might be better options, but this is what I use:

• four colums:  Account, Opened, Current Date, and Age
• Account:  list your accounts
• Opened:  list the opened month and year (I use 2/1/89 for February 1989)
• Current Date:  use "=TODAY()" for the formula
• Age:  use =DATEDIF(B19,C19,"m" ) -- remove space between closed quote and closing parenthesis--it produced a smiley face here, where B19 is the first account's Opened and C19 is the first account's Current Date cell, results are in months
• Skip a row after the last account is listed
• On the next row, under the Opened, use =COUNTA(B19:B34), where B19:B34 would be the first to last account's Opened cells, this should match your total number of accounts
• On the same row as the last step, under the Age, use =(SUM(D19:34)/12)/B36, where D19:34 would be the first to last account's Age cells, and B36 is the count of total accounts (rendered from the previous step

There may be better/more accurate setups, but this consistently matches the AAoAs that are on my credit reports.

Please post any improvements!