Why is datedif undocumented

If you liked my solution, please click on the Star - - to add to my reputation If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post. Register To Reply. Entia non sunt multiplicanda sine necessitate. Audere est facere. Re: DATEDIF function and other undocumented functions 2 good reads thank you both, but i think the real gain from this thread is the realization that N and T are both functions that could be used alot more than i am no which is not at all i am still learning, and this is another example of just how much there is to learn.

Thanks for the responces, both of you. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure. Microsoft Business. Microsoft Enterprise. In fact they say they only include it in recent versions for backward compatibility. From Happy LTD. Microsoft no longer supports this function in Excel.

It has been available since Excel 5, but Excel is the only version that ever documented it in its Help system. Substitute the cells you need to use. The following table lists the codes available with the returns. The years of the date are ignored. How are we doing? Please help us improve Stack Overflow.

Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. Ask Question. Asked 4 years ago.