DSO or Creating Named Formula

[sandwhale]

Hi,

I have the nagging feeling that this is a really obvious question, but here goes!

So, at work, I've been looking at some calculations to do with days sales outstanding and came across a spreadsheet put together by a colleague who has since left. For the most part it makes sense, but the calculation that relates to days sales outstanding (DSO) is confusing me somewhat. In the Excel sheet, there's an actual formula called DSO that does this calculation and I've uploaded a dumbed down version of what I'm looking at.

Wanting to know more, I've looked online for an Excel formula named DSO, but have come up short. I then checked Excel on my personal computer and found that no such formula exists in that instance. This makes me believe that somehow a named formula, as well as box for function arguments, has been created by this ex-colleague. If true, I've not seen this done before in Excel.

If I'm right can someone point me in the direction of where I might read up more on this. However, if DSO is a formula within Excel, can someone say why that doesn't appear in available formula or where guidance for it online might be?

Thanks a lot!

 

[Fluff]

Hi & welcome to MrExcel.
I suspect that it is a UDF & will probably be located in an add-in.

 

[sandwhale]

Ahh, thanks!
I don't suppose you know if there's a way to navigate directly from the formula to the code or add in that supports it?

 

[Fluff]

No there isn't. You would need to open up the VB Editor & search for a function called DSO

 

[sandwhale]

Thanks Fluff, it took a bit of digging but I found it.

Cheers for the help and I'm glad I've learned something new about Excel as a result of all this

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Fluff]

For future reference

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: [SOLVED] DSO or Creating Named Formula
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.