datedif()

[lezawang]

Hi
Why datedif() is hidden function? are they other functions hidden? Thank you very much.

 

[Eric W]

DATEDIF was originally created for compatibility with Lotus 1-2-3, but was never a "planned" Excel function. It's been retained for backward compatibility. I'm not aware of any other similar functions.

 

[xenou]

I can't say I've even tried it but supposedly M V L O O K U P() is a function that worked in Excel 2007 (yes, with the spaces):
https://chandoo.org/wp/march-2011-is-best-month-ever-and-other-news/

Or is this a prank? Pretty weird.

 

[Taul]

I can't say I've even tried it but supposedly M V L O O K U P() is a function that worked in Excel 2007 (yes, with the spaces):
https://chandoo.org/wp/march-2011-is-best-month-ever-and-other-news/

Or is this a prank? Pretty weird.

I think that post was dated 1st April

 

[xenou]

Haha yes - indeed just an april fools joke. Too bad. Was about to become my favorite excel formula!