How To Calculate Debtor Days Monthly. My jan opening stock in a1 is 1000. This is how i came up with result.

The result in feb month column c2 should be 60 days. The debtor days calculator is used to calculate the debtor days, which is a ratio used to work out how many days on average it takes a company to get paid for what it sells and measure how quickly cash is being collected from debtors. Calculate the average accounts receivable balance.