• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to calculate DSO by excel formula

rahullath9
Did You forget to continue Your previous thread?

DSO by Count back method

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
chandoo.org
You should able to give more details.
Isn't cell C15 Your expected result ... have Your expected formula.
 
vletm said:
rahullath9
Did You forget to continue Your previous thread?

DSO by Count back method

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
chandoo.org
You should able to give more details.
Isn't cell C15 Your expected result ... have Your expected formula.
Click to expand...


Hi, the only data i will be having is that mentioned in column A, B C Row no 5 to 9 and so on for all months. Result wanted is mentioned in Cell D6. This is for 1 Party. Such data will be for thousands of Parties, wherein i will be required to calculate DSO.

Rest calculations is for everyone's reference to suggest me the direct formula
 
You must log in or register to reply here.
Back
Top