Thanks:  0
Likes:  0

# Thread: DSO Days Sales Outstanding

1. ## DSO Days Sales Outstanding

Dear frnds...

I am looking for a simple tool to calculate the DSO (Days Sales Outstanding).

Can anyone help me...

I can come up with few ideas, but still need to get some guides from u huyz.

2. ## Re: DSO Days Sales Outstanding

dears any update

3. ## Re: DSO Days Sales Outstanding

My dear Genius, Zack Barresse, Joe4, PaddyD, Smitty, Richard Schollar, TestMod, Peter_SSs

pls help me

4. ## Re: DSO Days Sales Outstanding

Please try to be more patient.

Seeing some sample data may help.

5. ## Re: DSO Days Sales Outstanding

Apology Andrew...

i have a sample excel file... i can not make attachment.. can u help me pls

6. ## Re: DSO Days Sales Outstanding

You can put your workbook on a share like Box.com and post the URL. Or you can just copy some relevant data and paste it into a reply.

7. ## Re: DSO Days Sales Outstanding

let me come step by step....

i have 2 columns A= months and B= Days

i need to set cell A2 as a drop down list to select months, so cell A3 to A5 automatically shows the previous months in order.

Eg: if i select June in cell A2 , A3 will be May, A4 will April, A5 will March....

and B2 should show the number of days in particular month.

Eg: B2=30 , B3=31, B4=30, B5=31

Months Days
JUN 30
MAY 31
APR 30

this step can be a good beginning to requirement.

pls help

10. ## Re: DSO Days Sales Outstanding

To return the numbers of days in the month of the date in A1:

=DAY(EOMONTH(A1,0))

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•