Senior Contributor
bichonmom
Posts: 3,300
Registered: ‎05-05-2011
Re: How To Determine AAoA?

I didn't make the s/sht. All I did is copy and paste the OP and it has worked just the way it was in Excel. The only thing I did was to add my CC names in the left column and the acutal date they were opened in the appropriate column. The age automatically calculates based on today's date, which is in the formula somewhere. The other thing you need to do is note in the right col if an acct is open or closed, since that affects the formula somehow.

 

I always put the month/date/year. So, for July 2012, I would put 7/1/12, since AAoA is calc based on entire month.

 

 

 

 

 

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
EQ FICO 750 | TU FICO 761 (Walmart) | EX FAKO 767 | Goal: 800+

Edits, funky spacing and spelling due to my iPad not getting along with the forum editor!