Excel 提供了 DATEDIF 函数,以便支持来自 Lotus 1-2-3 的旧版工作簿。 在某些应用场景下,DATEDIF 函数计算结果可能并不正确。 有关详细信息,请参阅本文中的“已知问题”部分。 提示:如果要查找两个日期之间的天数,只需从较早日期中减去较晚的日期。 这很有效,因为日期在 Excel 中存储为数字。
{"__ref":"User:user:1715233"},"revisionNum":1,"uid":3731887,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: datedif function","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_...
datedif function Hi I am using a MacBook Air. When trying to use the datedif function to subtract two dates, it prevents me from selecting the second date, it returns the following error "There's a problem with th... Rajen66On a MBA myself. No problems with DATEDIF. But I wonder wh...
Warning:Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. For more information, please go to theknown issues section of the DATEDIF functionarticle. ...
=DATEDIF(A1,$B$1,"D")其实只要=$B$1-A1 单元格格式设为常规即可 =
To get detailed information about a function, click its name in the first column. Function Description DATE function Returns the serial number of a particular date DATEDIF function Calculates the number of days, months, or years between two dates. This function is useful in formulas wher...
应用举例：在C23单元格中输入公式：=DATEDIF(A23,TODAY(),"y")，确认后返回系统当前日期[用TODAY()表示）与A23单元格中日期的差值，并返回相差的年数。特别提醒：这是Excel中的一个隐藏函数，在函数向导中是找不到的，可以直接输入使用，对于计算年龄、工龄等非常有效。9、DAY函数 函数名称：DAY 主要...
DATEDIF Date and time: Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. DATEVALUE Date and time: Converts a date in the form of text to a serial number DAVERAGE Database: Returns the average...
Use the DATEDIF function to perform this calculation. Expand table Column1 Column2 Formula Description (possible result) 01-Jan-1995 15-Jun-1999 =DATEDIF([Column1], [Column2],"d") Returns the number of days between the two dates (1626) 01-Jan-1995 15-Jun-1999 =DATEDIF([Column1], [...
Use the DATEDIF function to perform this calculation. Expand table Column1 Column2 Formula Description (possible result) 01-Jan-1995 15-Jun-1999 =DATEDIF([Column1], [Column2],"d") Returns the number of days between the two dates (1626) 01-Jan-1995 15-Jun-1999 =DATEDIF([Column1], [...