Hello:
Please refer to attached excel sheet for referance.
Sheet1 has data which shows when invoice was generated and payment received.
From here i have calculated the # of days between the invoice and payment.
I need to know ( in Sheet2) how many invoices in 1-30 days, 31-60 days, etc in the table format as below:
# of Invoices
01 - 30 days
31 - 60 days
61 - 90 days
91 - 120 days
etc...
511 - 540 days
541 - 570 days
571 - 600 days
Please help and let me know if you have any questions..
Thank you
Riz Momin
Bookmarks