Excel Account Receivable Aging Report

W

Wanda_

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
 
Becky

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

Similar Threads

Access Default Microsoft Access Order Entry database issue 0
Access MS Access 2007 Aging Query 0
Excel Colour code dates 1
Accounts Receivable Aging Template 1
Conditional Accounts receivable Aging Analysis 0
Accounts Receivable Aging Report 1
Organization of Aging Report 2
Excel Need aid in Excel Formulas 3

Top