Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: DSO Days Sales Outstanding

  1. #1
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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.

    thanks in advance

  2. #2
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DSO Days Sales Outstanding

    dears any update

  3. #3
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DSO Days Sales Outstanding

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

    pls help me

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: DSO Days Sales Outstanding

    Please try to be more patient.

    Seeing some sample data may help.
    Microsoft MVP - Excel

  5. #5
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DSO Days Sales Outstanding

    Apology Andrew...

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

  6. #6
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default 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.
    Microsoft MVP - Excel

  7. #7
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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.

  8. #8
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DSO Days Sales Outstanding

    frnds... can any one help me iam tired about this

  9. #9
    Board Regular
    Join Date
    Feb 2006
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DSO Days Sales Outstanding

    pls help

  10. #10
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: DSO Days Sales Outstanding

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

    =DAY(EOMONTH(A1,0))
    Microsoft MVP - Excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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