Forum Discussion
DSO count back method
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 outstandin...
Hi Peter,
Could you give a broader explanation? I haven't used the LET function before and can't get it to work.
Could you give a broader explanation? I haven't used the LET function before and can't get it to work.
Firstly, do you use Excel 365 (or 2021)?
Are you happy to proceed with the sales in reverse order (recent to historic)?
[it is probably possible to reverse the order within the formula but makes it even more complicated]
Have you applied the defined name 'sales' to the sales row and named the value 'outstanding'?
From there the calculation first generates a running total showing the value which is than added to the current sales at each step. The value reached after the value is added is capped by 'outstanding'. The difference is the sales breakdown you require.