Formula to Calculate Days of Sales Outstanding Days

[kelvin-lkh]

Dear Excel Ninjas,

Below is the lengthy formula I used to calculate the Days of the Sales outstanding of receivable. This formula is not very dynamic as it does not cover if the receivable is longer than 5 months. Is there any formula could be more dynamic and less lengthy?

 

[vletm]

kelvin-lkh
If You are interesting to get answers, then You should able to explain -
what should Your formula do ( = to give result)?

 

[kelvin-lkh]

kelvin-lkh
If You are interesting to get answers, then You should able to explain -
what should Your formula do ( = to give result)?

Yes, my formula should give the result as per screenshot. Just that this formula is very lengthy and I need to keep adding on if the receivable is beyond the range of the DSO sales in my current formula.

so I m looking some formula which is shorter or more dynamic to cover the changes of the receivable.

 

[vletm]

kelvin-lkh
Did You read my second line - which is underlined - which starts with word what?

 

[kelvin-lkh]

my formula should give the number of days of the Sales which still remain at receivable. it use the receivable to back calculate the the months of the sales it brought forward from and then times the days of the respective month.