ExcelBanter - Aging reports

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Aging reports (https://www.excelbanter.com/excel-worksheet-functions/186508-aging-reports.html)

LBoyd

Aging reports

I need to report on aging of invoices based on when the service was incurred
vs. when it was actually paid.

Teethless mama

Aging reports

=B1-A1

"LBoyd" wrote:

I need to report on aging of invoices based on when the service was incurred
vs. when it was actually paid.

Fred Smith[_4_]

Aging reports

OK. You have two choices.

One, Google "aging report" -- you will get lots of examples.

Two, tell us what your spreadsheet looks like. Where is the amount, current
date, date to age, aging rules (30, 60, 90 days?), etc.

Regards,
Fred/

"LBoyd" wrote in message
...
I need to report on aging of invoices based on when the service was
incurred
vs. when it was actually paid.

All times are GMT +1. The time now is 01:53 AM.