Put into Place

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

Debtor Days Formula | Calculator (Excel Template)
Debtor Days Formula | Calculator (Excel Template) from www.educba.com

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.