Useless help topics

[Lewiy]

Most of us are probably aware that there a handful of functions in Excel which are not documented in the help files (pre-xl2007) such as DATEDIF. I’m wondering why things like this have been omitted, but they decided to include the following documentation for the CanPlaySounds Property in VBA:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

CanPlaySounds Property<o></o>

This property should not be used. Sound notes have been removed from Microsoft Excel.<o></o>

 

[Cbrine]

Lewiy,
From what I've stumbled across on the datedif() function, is that it's not documented because it was only put into excel to make it more compatible for individual's transitioning from Lotus 123. I believe the formula must have been available in lotus?

I read this on the internet so it must be true Sounds plausible though.

Cal

 

[Norie]

Lewiy

As far as I know DATEDIF has never been documented in Excel Help at all.

And I think Cal is right about Lotus, that's what I've heard anyway.

 

[Greg Truby]

Most of us are probably aware that there a handful of functions in Excel which are not documented in the help files (pre-xl2007) such as DATEDIF. I’m wondering why things like this have been omitted,...

From what I've stumbled across on the datedif() function, is that it's not documented because it was only put into excel to make it more compatible for individual's transitioning from Lotus 123. I believe the formula must have been available in lotus?
I read this on the internet so it must be true Sounds plausible though.

As far as I know DATEDIF has never been documented in Excel Help at all.
And I think Cal is right about Lotus, that's what I've heard anyway.

Don't you people have Google?

http://spreadsheetpage.com/index.php/oddity/the_datedif_function/

FYI - yes, that's Walkenbach's site. John recently redid the whole thing. He said he used ExpressionEngine (if I recall correctly) and really likes it.

 

[Cbrine]

Don't you people have Google?

Google...is that some kinda internet thing?

 

[Lewiy]

The point was really to highlight the uselessness of the CanPlaySounds property help file. It was almost not worth them putting that in!!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Also, in terms of compatibility…..is the CELL worksheet function not also there for that reason? Yet it is documented in full in the help files.

 

[Patience]

If they took away the help file for the CELL function it would render it pointless. I always know when and why I want to use the it, but I always have to use the help file to get me through.

 

[RoryA]

Have you read the Excel 2007 offline Help section about defined names? I think someone was bored...

 

[Richard Schollar]

Have you read the Excel 2007 offline Help section about defined names? I think someone was bored...

 

[Stormseed]

As far as I know DATEDIF has never been documented in Excel Help at all

I guess, DATEDIF() requires Analysis Toolpak to be installed ?