, EndDate)
DaysDiff = EndDate -StartDate
TSerial1 =TimeSerial(Hour(StartDate), Minute...(StartDate), Second(StartDate))
TSerial2 =TimeSerial(Hour(EndDate), Minute(EndDate), Second(EndDate...ydDaysDiff = EndDate -StartDate
NumOfMonths =DateDiff("m", StartDate, EndDate) + 1
StartDate...=xlDATEDIF(A1,A2,"ym")
返回两日期相差的月份数,与年无关。
=xlDATEDIF(A1,A2,"yd")
返回两日期相差的天数,与年无关。...=xlDATEDIF(A1,A2,"md")
返回两日期相差的天数,与年月无关。