DSO Days Sales Outstanding

[santhoshlk]

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

 

[santhoshlk]

dears any update

 

[santhoshlk]

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

pls help me

 

[Andrew Poulsom]

Please try to be more patient.

Seeing some sample data may help.

 

[santhoshlk]

Apology Andrew...

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

 

[Andrew Poulsom]

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.

 

[santhoshlk]

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.

 

[santhoshlk]

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

 

[santhoshlk]

pls help

 

[Andrew Poulsom]

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

=DAY(EOMONTH(A1,0))