DSO by Count back method

[rahullath9]

Hi,

need excel formula to calculate Days sales outstanding by count back method.

Attached excel file with Answer and explanation

Please note there will be only 3 inputs ( Month , Sales and Outstanding )

Regards
Rahul

 

[pecoflyer]

What do you mean by "count back method"? Be aware we do not necessarily know your professional jargon.
Please explain in words what you are trying to do, instead of obliging members to open your file.
Thx