各位朋友:

谁知道如何计算在excel表格中两个date类型数据之间的时间间隔,并能够以年,月,季度的形式输出? 谢谢

如2004-01到2007-09, 如何计算他们之间有多少个月,多少季度,多少年? 分别把月份,季度,年输出

Debug.Print "相隔" & DateDiff("m", "2004-01-01", "2007-09-01") & "个月" & vbCrLf & _
              "相隔" & DateDiff("q", "2004-01-01", "2007-09-01") & "个季度" & vbCrLf & _
              "相隔" & DateDiff("yyyy", "2004-01-01", "2007-09-01") & "年" & vbCrLf