Hi all,

I’m in need of a formula for calculating the DSO (daily sales outstanding) with the use of the count back method.

Calculation: 

Substract periodic sales (p5->P4 etc.) from outstanding money -> for every substraction count 28 days (1 period)

Do this until it cant be substracted without going negative

Divide remaining Outstanding by Periodic sales

P5 Outstanding : 12 000 000

P5 Sales             : 5 000 000 

= 12 000 000 – 5 000 000 = 7 000 000 (28 days)

P4 sales : 6 000 000

= 7 000 000 – 6 000 000 = 1 000 000 (28 days)

P3 Sales = 6 000 000

= 1 000 000 / 6 000 000 * 28 = 4,66… days = 5 days

28 + 28 + 5 = 61 days

Is it possible to fit this in one formula

​Hi all, I’m in need of a formula for calculating the DSO (daily sales outstanding) with the use of the count back method. Calculation: Substract periodic sales (p5->P4 etc.) from outstanding money -> for every substraction count 28 days (1 period)Do this until it cant be substracted without going negativeDivide remaining Outstanding by Periodic sales P5 Outstanding : 12 000 000P5 Sales             : 5 000 000 = 12 000 000 – 5 000 000 = 7 000 000 (28 days)P4 sales : 6 000 000= 7 000 000 – 6 000 000 = 1 000 000 (28 days)P3 Sales = 6 000 000= 1 000 000 / 6 000 000 * 28 = 4,66… days = 5 days 28 + 28 + 5 = 61 days Is it possible to fit this in one formula    Read More

​