Collection days is supposed to represent the average number of days business waits, on average, between delivering an invoice and receiving payment.
The formula for calculating collection days is:
=(Accounts_receivable_balance*360)/(Sales_on_credit*12)