Excel Account Receivable Aging Report


Joined
Nov 3, 2016
Messages
1
Reaction score
0
Hi
I am trying to do an aging report in Excel for invoices
0-30 days
31-60 days
61-90 days
over 90 days

what are the formulas for the columns.

Thank you
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum, Wanda.

Let's assume you have the following layout, with data starting in row 2 to allow for headings.

Column A - invoice amount
Column B - due date
Column C - 0-30 days
Column D - 31-60 days
Column E - 61-90 days
Column F - over 91 days

Then your formulas would be:

Column C: =IF((B2-TODAY())<=30,A2,"")
Column D: =IF(AND((B2-TODAY())>30,(B2-TODAY())<=60),A2,"")
Column E: =IF(AND((B2-TODAY())>60,(B2-TODAY())<=90),A2,"")
Column F: =IF((B2-TODAY())>90,A2,"")

Hope this helps! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top