officeba > 单独文章


Excel2007 找不到datedif() 函数的原因

 今天在学Excel2007常用公式时,发现一个函数datedif(),在帮助里面找不到相关的信息,但是又可以正常的使用。很奇怪,在网上搜索“Excel 2007datedif”,找到了原因。


The DATEDIF worksheet function
The DATEDIF function calculates the difference between two dates, and expresses the result in terms of months, days, or years.

If you have Excel version 5.0 or later, you can make use of the handy DATEDIF function in your formulas. But if you want to read about this function in the online help, you must have Excel 2000. For some reason, the function was never documented until Excel 2000. And the documentation was removed from Excel 2002.

The DATEDIF function has its origins in Lotus 1-2-3. Apparently, Microsoft included it in Excel for compatibility purposes. Why is it not documented? Who knows? But it's likely that lawyers are involved.


声明:欢迎各大网站转载本站文章,还请保留一条能直接指向本站的超级链接,谢谢!

时间:2008-05-09 23:17:38,点击:65824


【OfficeBa论坛】:阅读本文时遇到了什么问题,可以到论坛进行交流!Excel专家邮件:342327115@qq.com(大家在Excel使用中遇到什么问题,可以咨询此邮箱)。

【声明】:以上文章或资料除注明为Office自创或编辑整理外,均为各方收集或网友推荐所得。其中摘录的内容以共享、研究为目的,不存在任何商业考虑。如有任何异议,请与本站联系,本站确认后将立即撤下。谢谢您的支持与理解!


相关评论

我要评论

评论内容